FreeTDS Development Group

[Michael Peppler <mpeppler AT peppler.org>]

Here's some code from DBD::Sybase:

        if(imp_dbh->quotedIdentifier) {
            CS_INT value = 1;
            retcode = ct_options(connection, CS_SET, CS_OPT_QUOTED_IDENT, 
                                 &value, CS_UNUSED, NULL);
            if(retcode != CS_SUCCEED) {
                warn("Setting of CS_OPT_QUOTED_IDENT failed.");
            }
        }

ct_options() is used to set each of these options, also TEXTSIZE,
ROWCOUNT, etc.

Michael

Brian Bruns writes:
 > Michael,
 > 
 > Thanks, I replied to myself after a google search ;-)
 > 
 > BTW, what is the proper API way of doing it?  It'd be nice to support it.
 > 
 > Brian
 > 
 > On Tue, 29 Jan 2002, Michael Peppler wrote:
 > 
 > > Brian Bruns writes:
 > >  > FreeTDS does not manipulation of the SQL text prior to sending it to 
 > > the 
 > >  > server, except in the case of TDS 7.0 an ascii string is converted to 
 > >  > unicode when submitted.  The content is not changed however.
 > >  > 
 > >  > you may want to try something like 
 > >  > 
 > >  > SELECT "Date" from "Table" 
 > >  > 
 > >  > and there is a way to turn strict ansi compliance on (escapes me at 
 > > the 
 > >  > moment).  But long story short, ANSI defines " and ' as different 
 > > things.  
 > >  > ' (single quote) is used for string literals whereas " (double quote) 
 > > is 
 > >  > used for identifiers such as tables/columns with spaces in them, eg 
 > >  > SELECT "My Column" FROM "My Table With Spaces in the Name"
 > >  > 
 > >  > So double quotes with ansi compliance turned on may work.
 > > 
 > > For Sybase you normally need to set the "quoted identifier" option for
 > > the connection.
 > > 
 > > This can be done at the API level (though I suspect that FreeTDS
 > > doesn't support this yet), or via a language request:
 > > 
 > > SET quoted_identifier on
 > > 
 > > Michael
 > > 
 > > 
 > >  > On Tue, 29 Jan 2002, Shrock, Court wrote:
 > >  > 
 > >  > > Here is my problem:
 > >  > > 
 > >  > > The database that I need to access has table names that are normally
 > >  > > reserved--ie, "Date", "Bit", etc...I would like to be able to pass 
 > > the query
 > >  > > "SELECT Date FROM Events" or "SELECT * FROM Events ORDER BY Date", 
 > > but the
 > >  > > response acts as though it thinks Date is a function (I know one 
 > > does exist,
 > >  > > but I want to refer to the column name, not the function).  I know 
 > > this
 > >  > > because I get an error about wrong number of parameters with the 
 > > query
 > >  > > "SELECT Date() FROM Events".  Any ideas?
 > >  > > 
 > >  > > Does freetds do any manipulating of the query string before it 
 > > sends it to
 > >  > > the server listed in the freetds.conf?
 > >  > > 
 > >  > > I can "SELECT * FROM Events" and the Date column is returned, but 
 > > my problem
 > >  > > is that how can one include reference to "Date" in the WHERE, 
 > > GROUP, and
 > >  > > ORDER portions of the query?  Incidently, the "SELECT * FROM 
 > > Events" returns
 > >  > > the data that I need--connectivity is not a problem.
 > >  > > 
 > >  > > I am accessing the database via PHP-4.1.1/freeTDS-0.53 on 
 > > linux-2.2.19.
 > >  > > 
 > >  > > Many thanks,
 > >  > > Court
 > >  > > 
 > >  > > 
 > >  > > ---
 > >  > > You are currently subscribed to freetds as: [camber AT ais.org]
 > >  > > To unsubscribe, forward this message to $subst('Email.Unsub')
 > >  > > 
 > >  > 
 > >  > 
 > >  > ---
 > >  > You are currently subscribed to freetds as: [mpeppler AT peppler.org]
 > >  > To unsubscribe, forward this message to $subst('Email.Unsub')
 > > 
 > > 
 > 
 > 
 > ---
 > You are currently subscribed to freetds as: [mpeppler AT peppler.org]
 > To unsubscribe, forward this message to $subst('Email.Unsub')

-- 
Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
mpeppler AT peppler.org - mpeppler AT mbay.net
International Sybase User Group - http://www.isug.com