| SQL adaptation guide For Sybase ASE 15.5+ / Data manipulation | |
The ANSI string delimiter character is the single quote ( 'string'). Double quotes are used to delimit database object names ("object-name").
Example: WHERE"tabname"."colname" = 'a string value'
As Informix®, Sql Server Anywhere allows to use double quotes as string delimiters, if the QUOTED_IDENTIFIER session option is OFF (the default):
SET QUOTED_IDENTIFIER OFF
Remark: This problem concerns only double quotes within SQL statements. Double quotes used in BDL string expressions are not subject of SQL compatibility problems.
When the dbi.database.dbname.ifxemul.dblquotes FGLPROFILE option is set, the Sybase ASE database interface converts all double quotes to single quotes in SQL statements. The Sybase ASE database driver does not set the QUOTED_IDENTIFIER option implicitly.