Sort Order

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 nonbinary sort orders. Nonbinary sort orders are necessary for the correct ordering of character data and identifiers in European languages.

Use a nonbinary sort order if you have both:

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.