The application locale, or client locale, is used by the client library when making requests to the database server, to determine the character set in which results should be returned. If character-set translation is enabled (the default), the database server compares its own locale with the application locale to determine whether character set translation is needed. Different databases on a server may have different locale definitions.
For information on enabling character-set translation, see “Starting a database server using character set translation”.
The locale consists of the following components:
Language The language is a two-character string using the ISO-639 standard values: DE for German, FR for French, and so on. Both the database server and the client have language values for their locale.
The database server uses the locale language to determine:
Which language library to load.
The default collation when you create a Sybase IQ database
is ISO_BINENG. The language on the server has no effect
on this default.
The client library uses the locale language to determine:
Which language library to load.
Which language to request from the database.
For more information, see “Understanding the locale language”.
Character set The character set is the code page in use. The client and server both have character set values, and they may differ. If they differ, character set translation may be required to enable interoperability.
For machines that use both OEM and ANSI code pages, the ANSI code page is the value used here.
For more information, see “Understanding the locale character set”.
