Unicode sort orders

Adaptive Server version 12.5 includes additional Unicode sort orders. The following is an updated version of Table 7-6 in Chapter 7, “Configuring Character Sets, Sort Orders, and Languages,” that includes this information:

Table 4: Default Unicode sort orders

Name

Description

defaultml

Default Unicode ML ordering

nocasep

English, case insensitive, with preference

binary

Default binary ordering

thaidict

Thai dictionary ordering

scandict

Scandinavian, dictionary

scannocp

Scandinavian, case insensitive

dict

English dictionary

nocase

English, case insensitive

noaccent

English, accent insensitive

espdict

Spanish, dictionary

espnocs

Spanish, case insensitive

espnoac

Spanish, accent insensitive

rusdict

Russian, dictionary

rusnocs

Russian, case insensitive

cyrdict

Cyrillic, dictionary

cyrnocs

Cyrillic, case insensitive

elldict

Greek, dictionary

hundict

Hungarian, dictionary

hunnoac

Hungarian, accent insensitive

hunnocs

hungarian, case insensitive

turdict

Turkish, dictionary

turknoac

Turkish, accent insensitive

turknocs

Turkish, case insensitive

sjisbin

Japanese, sjis binary

eucjisbn

Japanese eucjis

gb2312bn

Chinese gb2312

cp932bin

Japanese cp932

big5bin

Chinese b165

euckcsbn

Korean euckcs

utf8bin

Matches Unicode UTF-8 binary sort order

gbpinyin

Chinese gb2312 pinyin