Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database configuration » International languages and character sets



A collation describes how to sort and compare characters from a particular character set or encoding. SQL Anywhere supports two collation algorithms: the SQL Anywhere Collation Algorithm (SACA), and the Unicode Collation Algorithm (UCA). SACA provides fast, compact, and reasonable sorting at the expense of linguistic correctness. UCA provides linguistic correctness, but with a small expense in storage requirements and execution time.

For more information about how to create a database with a specific collation, see Collation considerations, Changing the database collation, and Initialization utility (dbinit).

For information about customization of the UCA collation using collation tailoring syntax, see Collation tailoring options.

Collations in a SQL Anywhere database
SQL Anywhere Collation Algorithm (SACA)
Unicode Collation Algorithm (UCA)
Alternate collations
Collation considerations
How SQL Anywhere chooses the default collation for a new database
Changing the database collation