The following is a list of database collation related features that are no longer supported or deprecated and that may affect existing applications.
The creation of custom collations is no longer supported.
If you are rebuilding a database with a custom collation, the collation is preserved if you rebuild in a single step. If you choose to unload the database and then load the schema and data into a database that you create, then you must use one of the supplied collations.
The Collation utility (dbcollat) is not longer supported.
The SQLLOCALE environment variable is no longer supported and has been replaced by the SALANG and SACHARSET environment variables.
The ASLANG environment variable has been renamed SALANG.
The ASCHARSET environment variable has been renamed SACHARSET.
The SYSCOLLATION, SYSCOLLATIONMAPPINGS, and SYSINFO system tables have been deprecated. Collation mapping information is now stored as database properties.
See ”Compatibility views”in SQL Anywhere Server - Database Administration.
The SORTKEY function now uses the International Components for Unicode (ICU) library, instead of the Sybase Unicode Infrastructure Library (Unilib) and has new syntax. Sort key values created using a version of Sybase IQ prior to 15.0 do not contain the same values created using version 15.0 and higher. You should regenerate any sort key values in your database that were generated using a version of Sybase IQ prior to 15.0.
See “SORTKEY function [String]” in Chapter 4, “SQL Functions,” of Reference: Building Blocks, Tables, and Procedures.
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,” in the Utility Guide.
For a list of collations deprecated in Sybase IQ 15.0, see “Deprecated collations”. For more information on changes to database collations, see “Database collation improvements”.
