Enable Quoted Identifiers
- Last Updated: January 3, 2025
- 1 minute read
- DataDirect Connectors
- ODBC
- Documentation
Enable Quoted Identifiers
Attribute
EnableQuotedIdentifiers (EQI)
Purpose
Determines whether the driver supports the use of quoted identifiers.
Valid Values
0 | 1
If set to 1 (Enabled), the driver supports the use of
quoted identifiers. Double quotation marks (") must be used to enclose identifiers, such as
column and table names. Character strings must be enclosed in single quotation marks, for
example:
SELECT "au_id"
FROM "authors"
WHERE "au_lname" = 'O''Brien'
If set to 0 (Disabled), the driver does not support the
use of quoted identifiers and generates an error when quoted identifiers are
encountered.
Default
0 (Disabled)