Filter
Top Products
CHAPTER 7 Customizing Localization for Adaptive Server
Configuration Guide 91
Sort orders are located in sort order definition files (.srt files) that accompany
your character set definition files.
Note Available sort orders vary according to the character set installed on
Adaptive Server.
You can see the available sort orders for your character set by looking in the
.srt file for your language. Sort orders are stored in:
$SYBASE/charsets/<charset_name>/*.srt
For more information about localization files, see “Localization directories”
on page 94.
Table 7-16 describes the sort orders that you can specify at installation time or
at a later time using the
sqlloc utility.
Table 7-16: Sort orders available in Adaptive Server
Sort order name Description
Binary order Sorts all data according to numeric byte values for that character set. Binary order sorts
all ASCII uppercase letters before lowercase letters. Accented or ideographic
(multibyte) characters sort in their respective standards order, which may be arbitrary.
All character sets have binary order as the default. If binary order does not meet your
needs, you can specify one of the other sort orders either at installation or at a later time
by, using the
sqlloc utility.
Dictionary order, case
sensitive, accent sensitive
Case sensitive. Sorts each uppercase letter before its lowercase counterpart, including
accented characters. Recognizes the various accented forms of a letter and sorts them
after the associated unaccented letter.
Dictionary order, case
insensitive, accent
sensitive
Case-insensitive dictionary sort order. Uppercase letters are equivalent to their
lowercase counterparts and are intermingled in sorting results.
Dictionary order, case
insensitive, accent
insensitive
Case-insensitive dictionary sort order. Diacritical marks are ignored.