What does ODBC do about this issue?
Tim.
On Mon, Jan 07, 2002 at 09:57:16AM -0800, Michael Peppler wrote:
> Jonathan Leffler writes:
> > I was looking at it from the other (another?) point of view - namely
> > that of an application written using identifiers that must be quoted,
> > either because they contain characters that are not ordinarily allowed
> > in identifiers (eg blanks and punctuation) or because they are identical
> > with keywords.
>
> > So, a generic DBI
> > application cannot use double-quoted identifiers with Informix unless it
> > knows enough to set the Informix-specific DELIMIDENT environment
> > variable.
>
> Sybase (and MS-SQL) is the same - If keywords or spaces are used in
> identifiers the the QUOTED_IDENTIFIER connection attribute must be
> set, and the identifiers must be quoted.
>
> > Or, we could revise the DBI->connect method to allow the
> > application to indicate that it uses delimited identifiers:
> >
> > $dbh = DBI->connect($dsn, $user, $pass, { EnableDelimitedIdentifiers => 1,
>RaiseError => 1, ...});
> >
> > If this declarative option was available, DBD::Informix can do what is
> > necessary to make it work, and those drivers (the majority?) that do not
> > need to do anything to make delimited identifiers work can simply ignore
> > the attribute.
>
> Agreed - DBD::Sybase would need the same support, I don't think that I
> can handle it transparently.
>
> Michael
> --
> Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
> [EMAIL PROTECTED] - [EMAIL PROTECTED]
> International Sybase User Group - http://www.isug.com
