Skip to Content.
Sympa Menu

freetds - RE: ODBC and column names

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Thompson, Bill D (London)" <ThompBil AT exchange.uk.ml.com>
  • To: "'TDS Development Group'" <freetds AT franklin.oit.unc.edu>
  • Subject: RE: ODBC and column names
  • Date: Tue, 27 Aug 2002 22:45:26 +0100


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')





Archive powered by MHonArc 2.6.24.

Top of Page