My Oracle Support Banner

EMPTY (DB2 Varchar) Vs NULL (Oracle CHAR) Compare Pairs (Doc ID 2756826.1)

Last updated on JULY 20, 2024

Applies to:

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


Oracle GoldenGate Veridata is not handling EMPTY (DB2 Varchar) vs NULL (Oracle CHAR) compare pairs.

Data comparison between spaces or blank or NULL values has been handled in the compare-format string_en for Varchar/Varchar2 datatypes. Without string_en format, the comparison result are out-of-sync for these values.


After applying latest veridata patch and modifying the profiles CHAR/VARCHAR property to string_en , we still see records are out-of-sync for DB2 Null Value Vs Oracle BLANK value. This is applicable to DB2 VARCHAR datatype Vs
oracle CHAR data type


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.