1.25 CHARMAP
Valid For
Replicat
Description
Use the CHARMAP
parameter to specify that the character mapping file
overrides the character code point mapping.
Default
The encoding of the parameter file is operating system default character set.
Syntax
CHARMAP filename
The character mapping file format is as follows:
-- Sample character mapping file. -- Can use -- or COMMENT as comment line. -- Can use CHARSET parameter to specify file encoding. -- -- Source character set SOURCECHARSET shiftjis -- -- Target character set TARGETCHARSET ja16euc -- -- Character map definition by one code point. -- left hand is source and right hand target code point. \xa2c1 \x89\xa2\xb7 -- override \xa2c1 to \x89\xa2\xb7 -- -- Character map definition by range. Number of source and target characters must be the same. \x61 - \x7a \x41 - \x5a
Example
In the following example, the source and target character sets are different, and a character conversion definition is given using a character mapping file:
CHARMAP
charmapconv.txt
REPLACEBADCHAR FORCECHECK
This enables strict character set conversion and check code point even if the source and target are the same.
Add the following to your character mapping file:
SOURCECHARSET AL32UTF8 TARGETCHARSET UTF-16 \xef\xbf\xbd \x0020
Example
This example uses CHARMAP
with REPLACEBADCHAR
to change the target character even when the source and target character sets are the
same.
REPLACEBADCHAR FORCECHECK
CHARMAP
charmapconv.txt
This enables strict character set conversion and checks the code point even if the source and target are the same.
By enabling character set conversion for the same character sets, you may encounter some performance degradation.
Add the following to the character mapping file:
SOURCECHARSET windows-932 TARGETCHARSET windows-932 \x61 - \x7a \x41 - \x5a
Parent topic: Oracle GoldenGate Parameters