Sort order and character sets must be consistent everywhere for
subscriptions to be valid.
Subscriptions involve comparisons of data at the:
-
Primary data server during
materialization
-
Primary Replication Server during resolution
-
Replicate Replication Server during initialization
and dropping
-
Replicate data server during dropping