Selecting the default Unicode sort order

The default Unicode sort order is distinctly different from the sort order for the server’s default character set. This separate configuration parameter is a static parameter that requires that you restart your server and reindex the unichar data if it is changed. This sort order is identified using a string parameter, rather than a numeric parameter, to guarantee that the sort order is unique.

The available default Unicode sort orders are as follows:

**Table 7-6: Default Unicode sort orders**
Name	Description
defaulml	default Unicode ML ordering
binary	default binary ordering
altnoacc	CP850 alt: no accent
altdict	CP850 alt: lower-case first
altnocsp	CP850 alt: no case preference
thaidict	Thai dictionary ordering
scandict	Scandinavian, dictionary
scannocp	Scandinavian, case insensitive
dict	English dictionary
nocase	English, case insensitive
nocasep	English: no case preference
noaccent	English, accent insensitive
espdict	Spanish, dictionary
espnocs	Spanish, case insensitive
espnoac	Spanish, accent insensitive
rusnocs	Russian, case insensitive
cyrnocs	Cyrillic, case insensitive
elldict	Greek, dictionary
hundict	Hungarian, dictionary
hunnoac	Hungarian, accent insensitive
hunnocs	hungarian, case insensitive
utf8bin	matches Unicode UTF-8 binary sort order

You can add sort orders using external files in the $SYBASE/collate/Unicode directory. The names and collation IDs are stored in SYSCHARSETS. The names of external Unicode sort orders do not have to be in SYSCHARSETS before you can set the default Unicode sort order.

External Unicode sort orders are provided by Sybase. Do not attempt to create external Unicode sort orders.