FreeTDS Development Group

["Eric Deutsch" <edeutsch AT systemsbiology.org>]

Title: RE: [freetds] RE: ODBC and column names

Yes, there's a server-wide setting that controls case sensitivity.  E.g.:

sp_helpsort

Server default collation                                                                                                                                                                                                                                        

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode Data

> -----Original Message-----

> From: Brian Bruns [mailto:camber AT ais.org]

> Sent: Tuesday, August 27, 2002 2:14 PM

> To: TDS Development Group

> Subject: [freetds] RE: ODBC and column names

>

>

> I thought there was a setting to change this, no?

>

> Brian

>

> On Tue, 27 Aug 2002, Lowden, James K wrote:

>

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

> >

>

>

> ---

> You are currently subscribed to freetds as: [edeutsch AT systemsbiology.org]

> To unsubscribe, forward this message to leave-freetds-

> 127899P AT franklin.oit.unc.edu