Sybase 12.4.2 manual Understanding collations, Understanding the locale collation label, 328

Understanding collations

Understanding the locale collation label

Each database has its own collation.

The database server determines the collation label as follows:

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

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

2It uses an internal table to find a collation label corresponding to the language and character set.

Collation label values The collation label is a label for one of the supplied Adaptive Server IQ collations, as listed in “Understanding collations” on page 328.

Setting the SQLLOCALE environment variable

The SQLLOCALE environment variable is a single string that consists of three semicolon-separated assignments. It has the following form:

Charset=cslabel;Language=langlabel;CollationLabel=colabel

where cslabel, langlabel, and colabel are labels as defined in the previous sections.

For information on how to set environment variables, see the Adaptive Server

IQ Reference Manual.

Understanding collations

This section describes the supplied collations, and provides suggestions as to which collations to use under certain circumstances.

For information on how to create a database with a specific collation, see “Creating a database with a named collation” on page 346.

Displaying collations

Each time the database server opens an IQ database, it displays the following collation information:

328