Goldengate Replication Characterset Conversion Using CHARMAP Not Working (Doc ID 2063402.1)

Last updated on JANUARY 09, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.1.0 and later
Information in this document applies to any platform.

Symptoms

Using Oracle GoldenGate 12.1.2.1.x to replicate from DB2 v9.7 to Oracle 12.1.0.2 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:
BIG5        UTF8
8141        E5B395

Goldengate converts the character as below Using default conversion instead of CHARMAP override -
BIG5         UTF8
8141         EEBAB9

Cause

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