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

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » International Languages and Character Sets » Understanding locales

Understanding the locale language Next Page

Understanding the locale character set

Both application and server locale definitions have a character set. The application uses its character set when requesting character strings from the database server. The database server compares the database character set with that of the application to determine whether character set conversion is needed. If the database server cannot convert to and from the client character set, the connection fails.

  1. If the SACHARSET environment variable is set, its value is used to determine the character set. See SACHARSET environment variable.

    The database server uses SACHARSET only when creating new databases, and then only if no collation is specified.

  2. If the connection string specifies a character set, it is used. For more information, see CharSet connection parameter [CS].

  3. Open Client applications check the locales.dat file in the locales subdirectory of the Sybase release directory.

  4. Character set information from the operating system is used to determine the locale:

  5. On any other platform, a default code page cp1252 is used.

For more information about how to find locale settings, see Determining locale information.