skip to main content
Part 2: The 32-Bit/64-Bit Drivers : The SQL Server Legacy Wire Protocol Driver : Connection Option Descriptions : Enable Quoted Identifiers
  
Enable Quoted Identifiers
Attribute
QuotedID
Purpose
Determines whether the driver allows the use of quoted identifiers.
Valid Values
yes | no
Behavior
If set to yes (Enabled), Microsoft SQL Server 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
no (Disabled)
GUI Tab
Advanced tab