Configure your SAP® Sybase® IQ installation to handle international language issues.
The database collation sorts and compares all character data types in the database, including object names, such as table and column names.
SAP Sybase IQ takes advantage of the space efficiency and speed of the SAP® Sybase SQL Anywhere Collation Algorithm.
The 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 automatically treated as if the SORTKEY function has been invoked.
The SORTKEY function uses the International Components for Unicode (ICU) library, instead of the Sybase Unicode Infrastructure Library (Unilib®). Sort-key values created using a version of SAP Sybase IQ earlier than 15 do not contain the same values created using later versions. Regenerate any sort key values in your database that were generated using a version of SAP Sybase IQ earlier than 15.
The CREATE DATABASE parameter COLLATION supports specification of a collation for a database.
The collation of the database must match the collation used by the operating system. The default character set for CREATE DATABASE is ISO_BINENG.
The CP874toUTF8 utility converts data in the CP874 character set into UTF8 collation, supported by SAP Sybase IQ for the Thai language. The CP874toUTF8 utility calls the ICU library to perform data conversion. You can also use this utility to load data in the CP874 character set without converting the data to UTF8.
SAP Sybase IQ no longer supports custom collations. If you rebuild a database with a custom collation, rebuild in a single step to preserve the custom collation. If you unload the database and then load the schema and data into a database you create, you must use one of the supplied collations.
For more information about changes to database collations, and a list of collations deprecated in SAP Sybase IQ 15, see New Features in SAP Sybase IQ 15.0.
Use the iqunload utility to migrate to the current version of SAP Sybase IQ from an existing 12.7 database that was created with a deprecated collation.