Skip to Content.
Sympa Menu

freetds - Re: [freetds] Quoted Identifiers and TDS 4.2/7.0

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT freetds.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Quoted Identifiers and TDS 4.2/7.0
  • Date: Mon, 12 Sep 2005 22:45:59 -0400

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




Archive powered by MHonArc 2.6.24.

Top of Page