Quoted Identifiers

You can enable quoted identifier support for object names that need to be enclosed in double quote characters to be parsed correctly.

Quoted identifiers are object names that contain special characters such as spaces and nonalphanumeric characters, start with a character other than an alphabetic character, or that correspond to a reserved word, and need to be enclosed in double quote characters to be parsed correctly.

To ensure that replication proceeds correctly for objects with quoted identifiers created in versions of Adaptive Server earlier than 15.7, update the Adaptive Server system catalog after you upgrade Adaptive Server, but before you restore replication. See Updating the Adaptive Server System Catalog to Support Quoted Identifiers in the Replication Server Configuration Guide.

• Enable Quoted Identifiers Support
  Use create connection or alter connection with dsi_quoted_identifier to enable quoted identifier support.
• System Function to Support Quoted Identifiers
  The rs_set_quoted_identifier function string is added to set the DSI connection to Adaptive Server and Microsoft SQL Server.
• Mark Identifiers as Quoted
  Use the create replication definition or alter replication definition commands with the quoted parameter to mark identifiers as quoted identifiers.
• Quoted Identifiers Without Replication Definition Support
  Replication Server can add quotes to all identifiers without checking whether the identifier is quoted in a replication definition or in the primary Adaptive Server database.
• Mixed-Version Restrictions
  The quoted identifier feature is not supported in mixed version environments. For replication of a quoted identifier to succeed, the primary Replication Server and the Replication Server that connects to the replicate data server version must be version15.2 and later. However, intermediate Replication Servers in a route can be of lower versions.