QUOTED_IDENTIFIER Option [TSQL]

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.