My Oracle Support Banner

Veridata Comparing Empty (informix VARCHAR) VS NULL (oracle VARCHAR2) Out Of Sync. (Doc ID 2976228.1)

Last updated on JULY 20, 2024

Applies to:

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

Symptoms

On Ogg veridata: 12.2.1.4.220831 version, when compare empty (informix VARCHAR) VS NULL (oracle VARCHAR2) get OOS (out of sync).

even though setting server.convert_empty_to_null=true (12.2.1.4.210630 new feature) and truncate_spaces_len=0 or 1.

 

compare both tables via veridata and result show the 4th record is out of sync.

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
Cause
Solution
References


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