When you create a database, SQL Anywhere can choose a default collation based on operating system language and character set settings. In most cases, the default collation is a suitable choice, but you can also explicitly choose a collation to match your needs from the wide selection of supplied collations. In some cases, SQL Anywhere supports more than one collation for a particular language.
You should choose a collation that uses a character set and sort order that are appropriate for the data in your database. You can also specify collation tailoring options for additional control over the sorting and comparing of characters. For more information on creating databases, see Creating a database.
For more information about data sorting and international features, see SQL Anywhere international features.
Considerations when choosing a collation
How SQL Anywhere chooses the default collation for a new database