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 about creating databases, see Creating a database.

For more information about data sorting and international features, see SQL Anywhere international features.

See also

• Creating a database with a named collation
• Recommended character sets and collations
• CREATE DATABASE statement
• Initialization utility (dbinit)