skip to main content
Connection Option Descriptions : Enable Quoted Identifiers
  

Try DataDirect Drivers Now

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 0 (Disabled), applications that use quoted identifiers encounter errors when they generate SQL statements with quoted identifiers.

Default

0 (Disabled)

GUI Tab

Advanced tab