In a heterogeneous replication system, in which the primary and replicate data servers are different types, the data servers might not support the same character sets. In that case, 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.
Character set problems can produce data inconsistencies between the primary database and the replicate database. 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.
Using character set conversions slows performance.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
