6.166 TRAILCHARSET

Valid For

Replicat

Description

Note:

This parameter has been replaced by the SOURCECHARSET parameter but may still be retained in existing parameter files for backward compatibility.

Use the TRAILCHARSET parameter to supply a character set for the source data if the trail is written by an Extract version that is earlier than 11.2.1.0.0. In the earlier versions, the source character set is not stored in the trail.

When TRAILCHARSET is used, Replicat uses the specified character set as the source character set when converting character-type columns to the target character set. Replicat issues a warning message when it uses the TRAILCHARSET character set.

By default, Replicat performs character set conversion. This feature is controlled by the CHARSETCONVERSION (default) and NOCHARSETCONVERSION parameters. To use TRAILCHARSET, NOCHARSETCONVERSION cannot be used.

Default

Character set of the operating system

Syntax

TRAILCHARSET source_charset [, REPLACEBADCHAR];
source_charset

The ICU character-set identifier or an Oracle character-set identifier of the source database. For Oracle databases, Oracle GoldenGate converts an Oracle identifier to the corresponding ICU identifier for conversion to the character set that is specified with the NLS_LANG specification in the SETENV parameter in the Replicat parameter file.

REPLACEBADCHAR

Prevents Replicat from abending when a conversion attempt fails. The failed character is replaced with a replacement character for each target character set. The replacement character is pre-defined in each character set.

Examples

Example 1   
TRAILCHARSET ISO-8859-9;
Example 2   
TRAILCHARSET windows-932, REPLACEBADCHAR;
Example 3   
TRAILCAHRSET EUC-CN;