Understanding locales

Which language to request from the database.

For more information, see “Understanding the locale language” on page 324.

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” on page 325.

Collation label The collation label is the Adaptive Server IQ collation. The client side does not use a collation label. Different databases on a database server may have different collation labels.

For more information, see “Understanding the locale collation label” on page 328.

Understanding the locale language

The locale language is an indicator of the language being used by the user of the client application, or expected to be used by users of the database server.

For a list of supported locale languages, see “Language label values” on page 325.

For how to find locale settings, see “Determining locale information” on page 345.

The client library or database server determines the language component of the locale as follows:

1It checks the SQLLOCALE environment variable, if it exists.

For more information, see “Setting the SQLLOCALE environment variable” on page 328.

2On Windows and Windows NT, it checks the Adaptive Server IQ language registry entry.

3On other operating systems, or if the registry setting is not present, it checks the operating system language setting.

324

Page 344
Image 344
Sybase 12.4.2 manual Understanding the locale language, Understanding locales, 324