skip to main content
Part 2: The 32-Bit/64-Bit Drivers : The SQL Server Wire Protocol Driver : Connection Option Descriptions : Enable Quoted Identifiers
  
Enable Quoted Identifiers
Attribute
EnableQuotedIdentifiers (EQI)
Purpose
Determines whether the driver allows the use of quoted identifiers.
Valid Values
0 | 1
Behavior
If set to 1 (Enabled), the database enforces ANSI rules regarding quotation marks. Double quotation marks can only be used for 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 no (Disabled), applications that use quoted identifiers encounter errors when they generate SQL statements with quoted identifiers.
Default
0 (Disabled)
GUI Tab
Advanced tab