Goldengate Replication Characterset Conversion Using CHARMAP Not Working
Last updated on JANUARY 09, 2017
Applies to:Oracle GoldenGate - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
Using Oracle GoldenGate 22.214.171.124.x to replicate from DB2 v9.7 to Oracle 126.96.36.199 characters are not correctly translated when using CHARMAP.
The DB2 database was created using the Big5 character set and Oracle is using AL32UTF8.
For example, using 8141 -
Expected conversion result should be:
Goldengate converts the character as below Using default conversion instead of CHARMAP override -
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms