Re: SByte column types and question marked prefix...
Posted by: Reggie Burnett
Date: November 09, 2004 11:33AM

I've been waffling back on forth on issues such as the SByte one. I'll take your input into consideration. As to the ? issue, we have standardized on something. We have standardized on ?. Seriously, there are no ADO.net standards. As you pointed out, SqlClient and OdbcClient use different syntax. We use ? since the @ symbol is used for user variables in MySQL.

Early versions of the connector used @ for parameters, but the following SQL would be problematic.

set @myvar = 5;
select * from test where id = @myvar and id2 = @myparm

The connector can't tell which one is a user variable and which one is a parameter. One thing I considered was forcing users to use SQL server syntax for user variables but only when writing SQL for the connector. With this approach, the above SQL would be written as:

set @@myvar = 5;
select * from test where id = @@myvar and id2 = @myparm

Ultimately I chose not to do this since users would have to use different user variable syntax between the clients and some users store SQL inside databases and then feed it into Connector/Net. Maintaining the two SQL dialects would be trouble.

-reggie

Options: ReplyQuote


Subject
Written By
Posted
Re: SByte column types and question marked prefix...
November 09, 2004 11:33AM


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.