Unicode sort order

The Unicode sort order is different from the Replication Server sort order, and must be set independently. To set the Unicode sort order, use a text editor to add the following line to the Replication Server configuration file:

RS_unicode_sort_order=unicode_sort_order

unicode_sort_order can be any of the Sybase-supported Unicode sort orders listed in Table 7-1. The default value is binary.

Make sure that you suspend the connection to the data server and shut down Replication Server before changing the Unicode sort order.

To change the current sort order, use the procedure described in “Changing the character set and sort order”.

Table 7-1: Supported Unicode sort orders

Name

Description

defaultml

UTF-16 default ML

altnoacc

CP850 alt: no accent

altdict

cp850 alt: lowercase first

altnocsp

CP850 alt: no case preference

scandict

CP850 Scandinavian dictionary

scannocp

CP850 Scandinavian, no case preference

binary

UTF-16 binary

dict

Latin-1 English dictionary

nocase

Latin-1 English, no case

nocasep

Latin-1 English, no case preference

noaccent

Latin-1 English, no accent

espdict

Latin-1 Spanish dictionary

espnocs

Latin-1 Spanish no case

espnoac

Latin-1 Spanish, no accent

rusnocs

8859-5 Russian, no case

cyrnocs

8859-5 Cyrillic, no case

elldict

8859-7 Greek dictionary

hundict

8859-2 Hungarian dictionary

hunnoac

8859-2 Hungarian, no accents

hunnocs

8859-2 Hungarian, no case

turknoac

8859-9 Turkish, no accent

turknocs

8859-9 Turkish, no case

thaidict

CP874 Thai dictionary

utf8bin

UTF-16 ordering matching UTF-8

You can also specify a Unicode sort order for rs_subcmp. See rs_subcmp in the Replication Server Reference Manual.