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
