Replacing null characters v7
Note
These options apply only to the publication server.
A character consisting of binary zeros (also called the null character string) and represented as 000 in octal or 0x00 in hexadecimal can result in errors when attempting to load such data into a Postgres character column.
You might get the following error in the Migration Toolkit log file when performing a snapshot replication of an Oracle table that contains the null character string:
The same circumstance might also produce the following error in the Migration Toolkit log file:
If any of these errors occur, you can set an option that converts each null character encountered in character columns of the source tables to a space character or to any other character of your choice before loading the target tables.
Note
This option doesn't alter null characters encountered in columns with binary data types such as Oracle RAW and BLOB data types.
Set the following option:
replaceNullChar=true
This option results in the substitution of a space character for each null character encountered in the source character data. If you want to use a character other than a space character to replace each null character, use the following option in addition to replaceNullChar=true
.
nullReplacementChar=<char>
<char>
is a single character you want to substitute for the null character. For example, the following combination replaces each null character with the hash symbol #
.
replaceNullChar=true
nullReplacementChar=#