FreeTDS Development Group

["James K. Lowden" <jklowden AT freetds.org>]

Ben Gribaudo wrote:
> Is there any way to use FreeTDS/TDS 7.0 and set quoted identifiers to 
> off either in freetds.conf or in some kind of start up SQL script run by
> 
> FreeTDS? 

No.  I'm pretty sure quoted identifiers are set ON by the server when the
session identifies itself as ODBC.  db-lib turns that off in tdsdbopen()
-- that is, it turns off the "I'm an ODBC driver" bit.  You could do a
similar thing in ODBC if you wanted to.  I don't think it would interfere
with much else (although you're default date -> string conversion will
change).  The server doesn't *care* whether you're using the ODBC API or
not; it just has different defaults if you are.  

The standard answer is that ODBC adheres more closely to SQL-92 standards,
and that strings in SQL are single-quote delimited.  So you "should" be
moving your code in that direction, and meanwhile you can change the
behavior by sending a single SQL command at connect time.  

HTH.

--jkl