Char Column Type Gets Converted Into Its Equivalent HEX Value (Doc ID 2557188.1)

Last updated on AUGUST 21, 2019

Applies to:

Symptoms

In Goldengate Adapter, the CHAR column gets converted into its equivalent HEX value at the target.

For example instead of "M" cache holds value "4D".

Column definition is:
<COLUMN NAME> CHAR(1 CHAR)

Definitions file content for this column is:
<COLUMN NAME> 64 4 36 0 0 1 0 4 4 0 0 0 0 0 1 0 1 5 96 -1 1 0 0

Logdump data in trail file:
Column 3 (x0003), Len 5 (x0005)
0000 0001 4d | ....M

But the data which gets inserted into this column in cache is "4d"

Changes

Cause

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