Applies to:

Oracle GoldenGate - Version 11.2.1.0.2 and laterInformation in this document applies to any platform.

Symptoms

Multibyte characters not properly replicated between Oracle and Postgres when both databases are using Unicode character sets. For example the German extra character 'Ä' stored in the Oracle database is replicated into Postgres as 2 different characters 'Ã;' although the hex code of each character maches the hex code of the character stored in the Oracle database.