Sort Order Support

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.

rs_get_sortorder System Function

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.

Related information
rs_get_sortorder