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.

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

 See also