My Oracle Support Banner

How To Convert Self-created Characters To UTF8 While Migrating DB2/AS400 To Oracle Using GoldenGate, the DB2/AS400 has CCSID 37,937,28709,65535 for its table columns. (Doc ID 2831229.1)

Last updated on JANUARY 06, 2022

Applies to:

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

Goal

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.

I think GoldenGate should have many in-built encoding mappings that help to convert characters from each CCSID to UTF8.
Where are the encoding mappings?
Can we edit the encoding mappings so that we can add the self-created character mapping?

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.