When you create a database, SQL Anywhere can choose a default collation based on operating system language and character set settings. Usually 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. SQL Anywhere can support 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.

 See also