Character Set and Sort Order

If you change the character set or sort order of Adaptive Server, you must also change the character set or sort order of each Replication Server that manages replication for the server and each associated RSSD that resides on a separate Adaptive Server.

If you change the sort order of Adaptive Server, you must also change the sort order of the replicate Replication Server and replicate data server to ensure that subscriptions are processed consistently.

After changing the character set or sort order, subscription semantics may change. Sort order changes can have obvious consequences. Suppose a subscription contains the clause “where last_name = MacGregor.” If the sort order is changed from dict to binary, for example, “MacGregor” no longer qualifies for sorting.

Synchronize the Primary and Replication Databases

After you change the character set or sort order, make sure that the primary and replicate databases are resynchronized. Sybase recommends that you use one of these methods:

  • Use rs_subcmp after changing the character set or sort order, or

  • Purge all subscriptions before changing the character set or sort order, and then rematerialize all subscriptions after changing the character set or sort order.

Note: Use the purge and rematerialize method if any subscriptions contain character clauses. Only this method ensures that subscriptions with character clauses are resynchronized.
Parent topic: International Replication Design Considerations