My Oracle Support Banner

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

Last updated on MARCH 03, 2024

Applies to:

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


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

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


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


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

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