How to convert self-created characters to UTF8 while migrating DB2/AS400 to Oracle using GoldenGate
Hi,
We are having a project to migrate data from DB2/AS400 to Oracle using Oracle GoldenGate.
The DB2/AS400 has CCSID 37,937,28709,65535 for its table columns.
There may be double-byte Chinese characters storing in single byte columns.
Further more, customer may create some Chinese characters which not exists in the standard CCSID character set by using the reserved area.
When migrating data from the DB2/AS400 to oracle, we must convert all characters to Oracle's AL32UTF8.
It seems GoldenGate cannot convert some Chinese characters correctly, especially the self-created Chinese characters.
Do you have any idea?
I think GoldenGate should have many in-built encoding mappings used to convert characters from corresponding CCSID to UTF8.
We are having a project to migrate data from DB2/AS400 to Oracle using Oracle GoldenGate.
The DB2/AS400 has CCSID 37,937,28709,65535 for its table columns.
There may be double-byte Chinese characters storing in single byte columns.
Further more, customer may create some Chinese characters which not exists in the standard CCSID character set by using the reserved area.
When migrating data from the DB2/AS400 to oracle, we must convert all characters to Oracle's AL32UTF8.
It seems GoldenGate cannot convert some Chinese characters correctly, especially the self-created Chinese characters.
Do you have any idea?
I think GoldenGate should have many in-built encoding mappings used to convert characters from corresponding CCSID to UTF8.
0