QUOTED_IDENTIFIER option [TSQL]

Function

Controls the interpretation of strings that are enclosed in double quotes.

Allowed values

ON, OFF

OFF for Open Client connections.

Default

ON

Description

QUOTED_IDENTIFIER controls whether strings enclosed in double quotes are interpreted as identifiers (ON) or as literal strings (OFF). This option is included for Transact-SQL compatibility.

Sybase Central and Interactive SQL set QUOTED_IDENTIFER temporarily to ON if it is set to OFF. A message is displayed informing you of this change. The change is in effect only for the Sybase Central or Interactive SQL connection. The JDBC driver also temporarily sets QUOTED_IDENTIFIER to ON.

See also

Appendix A, “Compatibility with Other Sybase Databases” in Reference: Building Blocks, Tables, and Procedures