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 © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0