QUOTED_IDENTIFIER option [TSQL]

Function

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

Allowed values

ON, OFF

OFF for Open Client and JDBC connections

Default

ON

Description

This option controls whether strings enclosed in double quotes are interpreted as identifiers (ON) or as literal strings (OFF). The QUOTED_IDENTIFIER 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.

For more information, see Appendix A, “Compatibility with Other Sybase Databases”.