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

SQL Anywhere 12.0.0 » SQL Anywhere Server - Database Administration » Configuring your database » International languages and character sets » Choosing collations


How SQL Anywhere chooses the default collation for a new database

When a new database is created, and the collation is not explicitly specified, SQL Anywhere uses the language and character set to determine the collation.

  • The language comes from the SALANG environment variable (if it exists), the registry, or the operating system. See SALANG environment variable.

  • The character set comes from the SACHARSET environment variable (if it exists) or the operating system. See SACHARSET environment variable.