Re: Gamma?
Posted by: Reggie Burnett
Date: December 09, 2004 03:19PM

First, there is absolutely no standard that says a provider should use @ to mark parameters in SQL. Both the OleDbClient and OdbcClient use ?. We are using ? to mark parameters since the @ symbol is used by MySQL to mark user variables.

Second, what evidence do you have that the MySqlValue and derived classes are slower?

Third, I have commited some code working on the date time issue. This is not an easy issue to deal with. On one hand, there are people who want to use zero datetimes in their databases and have code like reader["datetimefield"].ToString() print out '00-00-0000 00:00:00'. Try to make this happen by returning a DateTime stuct. However, we really should return DateTime structs in most cases so what should we do?

The approach I have taken last is to include a connection string option called "allow zero datetime". When yes, MySqlDateTime objects will be returned from GetValue(i). When no, DateTime structs will be returned.

I am open to any suggestions you might have.


Options: ReplyQuote

Written By
December 06, 2004 11:37AM
December 07, 2004 09:55AM
December 09, 2004 02:50PM
Re: Gamma?
December 09, 2004 03:19PM
December 09, 2004 03:50PM
December 09, 2004 04:11PM
December 09, 2004 04:56PM
December 09, 2004 06:08PM
December 09, 2004 09:07PM
December 10, 2004 02:07PM
December 10, 2004 02:25PM
December 10, 2004 02:48PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.