Simon Oliver wrote:
>
> I propose the addition of one new database handle method:
>
> quote_identifier(string, inherited)
Yeah! We need that!
> I propose the addition of four new DBI attributes:
>
> QuotedIdentifierStart (string, inherited), " (double quote) by default
> sets the start string for quoted identifiers
>
> QuotedIdentifierEnd (string, inherited), " (double quote) by default
> sets the terminating string for quoted identifiers
>
QuotedIdentifierStart == QuotedIdentifierEnd in ODBC (see
SQLGetInfo, SQL_IDENTIFIER_QUOTE_CHAR).
Of course, your proposal is more general.
> QuotedIdentifiers (boolean, inherited), disabled by default
> indicates if quoted identifiers are in use
>
???
> TableIdentifiers (arrayref, inherited), [1,2] by default
> list of identifiers that uniquely describe a table,
> an array of zero based column indexes as returned from $dbh->table_info()
>
We reflected on this point a long time: Do we really need that?
Maybe a driver returns a catalog name, but does not permit it in
SQL statements? Do you have an example?
Steffen G�ldner
Olga Voronova