Replication Server Character Sets

The character set used by the Replication Server must match the character set used by the data servers and Replication Agents it controls for replication to work properly.

The character set must be compatible with the character sets of the other Replication Servers in the system. By default, rs_init configures Replication Server with the native character set for your platform.

When you create a subscription, Replication Server copies the requested data from the primary database to the replicate database in a process known as subscription materialization. During subscription materialization, the primary data server converts character data to the replicate Replication Server character set. Make sure that the replicate Replication Server character set is installed at the primary data server if it is different from the primary data server character set.

Similarly, when you create a route, make sure that the character set of the destination Replication Server is installed at the data server of the source Replication Server RSSD.