The sort order, or collation sequence, used by a server determines how character data and identifiers are compared and ordered. A sort order is determined by the character set.
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.
Use a non-binary sort order if you have both of the following:
Differing character sets between the primary and replicate data servers, and
Data with 8-bit characters,
and you intend to do either of the following:
Include columns with this data in the where clause of a subscription, or
Query the database with an order by clause involving the columns with this data.
