Character Sets

Setting character sets avoid problem that can produce data inconsistencies between the primary database and the replicate database.

In a heterogeneous replication system, in which the primary and replicate data servers are different types, servers may not support all the same character sets. In such cases, replication system components must perform at least one character set conversion (from the primary data server’s character set to the replicate data server’s character set).

Even in a homogeneous replication system, in which both primary and replicate data servers are the same type, character set conversions might be required if replication system components reside on more than one type of platform.

To avoid character set problems, you must either:

Use the same character set on all servers and platforms in the replication system, or
Use compatible character sets on all servers and platforms in the replication system, and configure replication system components to perform the appropriate character set conversions.

For more information about setting and overriding the default character set, see the appropriate Replication Agent documentation.