FreeTDS Development Group

["Varley, David(CBorn at Alcoa)" <David.Varley AT alcoa.com.au>]

Identifier case is an attribute on SQL Server, defaulting to MIXED.
This has caused me some pain in the past, as the DTS tools seem to
randomly mix case rather than keeping as returned by queries. This
works on SQL server transfers, but bombs out when trying to use the
tools for transfers between SQL Server and case sensitive databases
such as PostgresQL.

Poor coding by Microsoft, or a deliberate ploy to reduce interoperability?
You be the judge! :)


>From SQL Server Books Online:

sp_server_info
--------------
Returns a list of attribute names and matching values for Microsoft® SQL
Server(tm), the database gateway, or the underlying data source.

Syntax:
sp_server_info [[@attribute_id =] 'attribute_id']

ATTRIBUTE_ID: 16
ATTRIBUTE_NAME: IDENTIFIER_CASE
Description: Specifies the user-defined names (table names, column names,
stored procedure names) in the database (the case of the objects in the
system catalogs).
ATTRIBUTE_VALUE: MIXED or SENSITIVE, depending upon whether SQL Server is
set to case-sensitive or case-insensitive.
 
Default value is MIXED

David

> -----Original Message-----
> From: Thompson, Bill D (London) [mailto:ThompBil AT exchange.uk.ml.com]
> Sent: Wednesday, 28 August 2002 7:45 AM
> To: TDS Development Group
> Subject: [freetds] RE: ODBC and column names
> 
> 
> 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