Mazovia (CP790) Encoding In GoldenGate For Informix

(Doc ID 2343972.1)

Last updated on JANUARY 11, 2018

Applies to:

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

Symptoms

We are loading data from Informix database using Mazovia (CP790) encoding through HotCache into Coherence cache.
Source database is Informix
We encountered problem in polish characters encoding.
Definition file states that DB encoding is standard DOS - CP437.

For example, character 0x9c is loaded into the cache as Unicode "POUND SIGN" instead of "LATIN CAPITAL LETTER L WITH STROKE"

* Definition file sample - Column identification (Column 56):

Database type: INFORMIX
Character set ID: cp437
National character set ID: UTF-8
Locale: pl_PL
Case sensitivity: 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11
TimeZone: NFT
*
Definition for table <table_name>
Record length: 1266
Syskey: 0
(...)
identification 64 32 942 0 0 1 0 32 32 0 0 0 0 0 1 0 0 0 12 -1 0 0 0
(...)

* Sample record - problematic character in 0x9c in Column 56:

2016/05/13 18:35:43.510.492 Insert Len 109 RBA 805496738
Name: <table_name>
After Image:
(...)
Column 56 (x0038), Len 14 (x000e)
0000 000a 5441 4a4e 4548 4153 9c4f | ....TAJNEHAS.O
Column 64 (x0040), Len 10 (x000a)
0000 0000 0000 0000 0100 | ..........
Column 65 (x0041), Len 10 (x000a)
0000 0000 0000 0000 0101 | ..........

Changes

 

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