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

SQL Anywhere 12.0.1 » SQL Anywhere Server - Database Administration » Database configuration » International languages and character sets


Collation considerations

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

Considerations when choosing a collation
Collation tailoring options
How SQL Anywhere chooses the default collation for a new database