Enable ANSI Quotes

ANSI_Quotes

Key Name	Default Value	Required
ANSI_Quotes	Clear (false)false	No

Description

This option specifies whether the connector treats a quotation mark (") as an identifier quote character or a string quote character.

• Enabled (true)true: The connector treats a quotation mark (") as an identifier quote character.

When the connector connects to the data store, it executes the following statement:

SET SESSION sql_mode = 'ANSI_QUOTES'.

• Disabled (false)true: The connector treats a quotation mark as a string quote character.

Related topics

• Using a Connection String
• Configuring Connection Options
• Creating a Data Source Name
• Configuring a DSN-less Connection
• Connection Configuration Options