My Oracle Support Banner

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

Last updated on AUGUST 21, 2019

Applies to:

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

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


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