Support of database collations has changed in Sybase IQ 15.0 to take advantage of the space efficiency and speed of the SQL Anywhere Collation Algorithm.
The new database option SORT_COLLATION allows implicit use of the SORTKEY function on ORDER BY expressions. When the value of this option is set to a valid collation name or collation ID, any string expression in the ORDER BY clause is treated as if the SORTKEY function has been invoked.
See “SORT_COLLATION option” in Chapter 2, “Database Options,” in Reference: Statements and Options.
The SORTKEY function now uses the International Components for Unicode (ICU) library, instead of the Sybase Unicode Infrastructure Library (Unilib®) and has new syntax.
For more information, see “SORTKEY function [String]” in Chapter 4, “SQL Functions,” of Reference: Building Blocks, Tables, and Procedures.
The new CREATE DATABASE parameter COLLATION supports specification of a collation for a database.
See CREATE DATABASE statement in Chapter 1, “SQL Statements,” in Reference: Statements and Options.
The CP874toUTF8 utility converts data in the CP874 character set into UTF8 collation, a collation supported by Sybase IQ for the Thai language. The CP874toUTF8 utility now calls the International Components for Unicode (ICU) library to perform data conversion. You can also load data in the CP874 character set without converting it to UTF8 using this utility.
See “CP874toUTF8 utility” in Chapter 3, “Database Administration Utilities,” ofUtility Guide.
See ”Understanding collations” in SQL Anywhere Server - SQL Usage.
