Replication Server Sort Order

The sort order controls which rows of a table belong in a subscription that has a where clause involving character data.

The sort order also controls how the identifiers you enter are recognized with regard to case sensitivity, accents, and so forth.

You can specify any Sybase-supported sort order that is compatible with your character set. For replication to work properly, all sort orders in your replication system should be the same.

By default, rs_init configures Replication Server with the binary sort order. Available sort orders vary, depending on the character set you plan to install. Sort orders are located in the Sybase release directory in the directory charsets/charset_name, where charset_name is the name of the character set.

See the Replication Server Design Guide for guidelines on configuring languages, character sets, and sort orders in your replication system.