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.