In setting up a replication system, it is strongly recommended that all servers at a given Replication Server site use the same character set. It is also recommended that all of the Replication Servers in your replication system use compatible character sets.
Follow these guidelines to minimize character-set conversion problems:
Use 7-bit ASCII (if possible) for all data servers, data, and object names.
If your data and object names are all 7-bit ASCII or if all of your data servers and Replication Servers use the same character set, character set conversion will not present problems.
If you need to replicate data between a single-byte and a multibyte server, restrict character data and object names to 7-bit ASCII to avoid corruption. Otherwise, you may experience problems. For example, Replication Server does not restrict server names to 7-bit ASCII, but Adaptive Server or the Connectivity Libraries may do so.
When replicating between servers with different but compatible character sets (for example, ISO_1 and CP850), make sure that object names and character data do not include any 8-bit characters that are not common to both character sets.
