Replication Server uses sort order, or collating sequence, to determine how character data and identifiers are compared and ordered. Replication Server supports all Sybase-supported sort orders, including non-binary sort orders. Non-binary sort orders are necessary for the correct ordering of character data and identifiers in European languages.
You specify sort orders with the RS_sortorder parameter in the Replication Server configuration file. 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.
Each time Replication Server connects to a data server, it executes rs_get_sortorder, which obtains the sort order used by the data server. If it is not what is expected, Replication Server prints a warning message to the error log file. For more information, see rs_get_sortorder.
