Unicode parser

In versions of Adaptive Server earlier than 12.5.1, you had to set the server’s default character set to UTF-8 to use the unichar and univarchar datatypes.

This restriction has been removed in version 12.5.1. You can now use unichar and univarchar datatypes with any default character set without first having to configure your default character set to UTF-8.

By incorporating syntax from the new SQL2002 standard, you can now use escape sequences to specify any Unicode character in a string literal. If a string literal (whether or not it makes use of the new syntax) contains characters that cannot be represented in the server’s default character set, the literal is promoted from the varchar datatype to the univarchar datatype.

See Chapter 7, “Configuring Character Sets, Sort Orders, and Languages” in the System Administration Guide for more information.