Wrong unicode value is replicated by OGG adaptor to Kafka (Doc ID 2210356.1)

Last updated on DECEMBER 02, 2016

Applies to:

Oracle GoldenGate Application Adapters - Version 12.1.2.1.6 and later
Information in this document applies to any platform.

Symptoms

I am replicating from source oracle db (UTF8) to kayka, and found the unicode data were not correct, unless setting
LANG=DE_DE.UTF-8, and restart manager and adaptor
.
example:
1. from DB
DOA??
Typ=1 Len=9 CharacterSet=UTF8: 44,4f,41,e8,aa,ac,e6,98,8e
.
2. from trail:
44 4f41 e8aa ace6 988e
.
3. from Kafka
================
# Test case1 (This is our AIX Default)
NON-PROD:631:crmrtl3t_brawn:/usr/orasys/dref122> env | grep LANG
LANG=en_US
NLS_LANG=
We did a restart of Adaptor(MGR & REPLICAT adaptor) and gets this at kafka
C_SUMMARY ?DOA?? ?DOA??
RC_DESCRLONG ? ?
.
# Test case2
NON-PROD:649:crmrtl3t_brawn:/usr/orasys/dref122> env | grep LANG
LANG=en_US
NLS_LANG=American_America.UTF8
We did a restart of Adaptor(MGR & REPLICAT adaptor) and gets this at kafka
.
?RC_SUMMARY ?DOA?? ?DOA??
.
# Test case 3 (Works )
LANG=DE_DE.UTF-8 N
LS_LANG=
We did a restart of Adaptor(MGR & REPLICAT adaptor) and gets this at kafka

RC_SUMMARY │DOA** │DOA**
=============

 



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