My Oracle Support Banner

In DB2, Data Getting Converted From Character Set UTF-8 To ISO-8859-1 Even Though The Target Character Set Is UTF-8 (Doc ID 2433307.1)

Last updated on AUGUST 09, 2018

Applies to:

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

Symptoms

Replicat in DB2 failing with below error:

2018-07-25T03:34:08.305GMT ERROR OGG-03533 Oracle GoldenGate Delivery for DB2, re2e1cia.prm: Conversion from character set UTF-8 of source column <Column Name> to character set ISO-8859-1 of
 target column <Columns Name>failed because the source column contains a character 'ef bf bd' at offset 9 that is not available in the target character set.
2018-07-25T03:34:08.311GMT ERROR OGG-01668 Oracle GoldenGate Delivery for DB2, re2e1cia.prm: PROCESS ABENDING.

Even though the database character set at source and target database is UTF-8.

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.