Golden Gate replicate - Source Table column CHAR, Target VARCHAR2
Hello,
We have implemented GG across two DB on 11.2.0.4. The GG version is 12.1.2. There are tables having column data type as CHAR, while the data type defined in target is VARCHAR2.
The replicate is abending with 'NO Data Found' error, as it is filtering out the first 2 bytes from the key column value while updating. The key column value 2014223301 is read as 14223301.
Is it due to the way the CHAR and and VARCHAR are written to trail file? My understanding is for CHAR, 2 bytes are written before the ASCII value, while for VARCHAR, 4 bytes are written followed by ASCII value