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.

Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0