SQL Anywhere® Server - Database Administration  > International Languages and Character Sets  > Understanding collations  > 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.