Filter
Top Products
Understanding collations
328
Understanding the locale collation label
Each database has its own collation.
The database server determines the collation label as follows:
1 It checks the SQLLOCALE environment variable, if it exists.
For more information, see “Setting the SQLLOCALE environment
variable” on page 328.
2 It 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: