FreeTDS Development Group

["Thompson, Bill D (London)" <ThompBil AT exchange.uk.ml.com>]

Man - I should get my facts straight before I open my big mouth! 
:-O

At the risk of prolonging this debate further than it deserves, I believe
the default behaviour of SQL 2000 is case insensitive.

BilL


> -----Original Message-----
> From: Lowden, James K [SMTP:LowdenJK AT bernstein.com]
> Sent: Tuesday, August 27, 2002 10:06 PM
> To:   TDS Development Group
> Subject:      [freetds] RE: ODBC and column names
> 
> > From: Thompson, Bill D (London) [mailto:ThompBil AT exchange.uk.ml.com]
> > Sent: August 27, 2002 4:47 PM
> >
> > column names (although SQL 7/2000 are case insensitive). 
> 
> Huh?
> 
> 1> select * from b select * from B
> 2> go
>  b
>  -----------
>            1
> 
> (1 row affected)
> Msg 208, Level 16, State 1, Server NTS0214, Line 1
> Invalid object name 'B'.
> 
> 1> select B from b
> 2> go
> Msg 207, Level 16, State 3, Server NTS0214, Line 1
> Invalid column name 'B'.
> 
> 1> select cast(@@version as varchar(50))
> 2> go
> 
>  --------------------------------------------------
>  Microsoft SQL Server  7.00 - 7.00.859 (Intel X86)
> 
> (1 row affected)
> 
> Who you calling insensitive?  
> 
> --jkl
> 
> 
> The information contained in this transmission may contain privileged and
> confidential information and is intended only for the use of the person(s)
> named above.  If you are not the intended recipient, or an employee or
> agent
> responsible for delivering this message to the intended recipient, any
> review, dissemination, distribution or duplication of this communication
> is
> strictly prohibited. If you are not the intended recipient, please contact
> the sender immediately by reply e-mail and destroy all copies of the
> original message. Please note that for certain accounts we do not accept
> orders and/or instructions by e-mail, and for those accounts we will not
> be
> responsible for carrying out such orders and/or instructions. Kindly
> refrain
> from sending orders or instructions by e-mail unless you have confirmed
> that
> we accept such communications for your account. Please also note that to
> satisfy regulatory requirements we review the outgoing and incoming e-mail
> correspondence of staff members serving certain functions.
> 
> 
> 
> ---
> You are currently subscribed to freetds as: [thompbil AT exchange.uk.ml.com]
> To unsubscribe, forward this message to
> $subst('Email.Unsub')