COLCHARSET
Valid For
Extract, Replicat, and DEFGEN
Description
Use COLCHARSET
clause to specify particular column character set or disable character set conversion. This parameter overrides the column character set for the specified column.
The character set specified by the COLCHARSET
parameter overrides the character set in the trail file, the character set specified by the SOURCECHARSET OVERRIDE
parameter and the character set specified by the CHARSET
parameter.
The character set specified by the COLCHARSET
Replicat parameter overrides the column level character set specified in the source table definition file.
If the COLCHARSET
is specified for DEFGEN file format less than level four, the parameter is ignored and warning message is issued. The column level character set attribute for the older table definition file format is not output.
The COLCHARSET
parameter overrides the source column level character set and change the Replicat character set conversion behavior by assuming the source column character set as specified character set.
Default
None
Syntax
COLCHARSET character_set (column [, ...])
Examples
- Example 1
-
The following example specifies multiple columns.
TABLE SchemaName.TableName, COLCHARSET( WE8MSWIN1252, col0, col2 );
- Example 2
-
The following example specifies a different character set.
MAP SchemaName.*, TargetName *.*, COLCHARSET( WE8MSWIN1252, col1 ), COLCHARSET( WE8ISO8859P1, col2 )
- Example 3
-
The following example specifies different character set.
MAP SchemaName.*, TargetName *.*, COLCHARSET( WE8MSWIN1252, col1 ), COLCHARSET( WE8ISO8859P1, col2 )
- Example 4
-
The following example specifies a wildcard.
MAP SchemaName.*, TargetName *.*, COLCHARSET( WE8MSWIN1252, col* )
- Example 5
-
The following example disables character set conversion on particular column.
MAP SchemaName.*, TargetName *.*, COLCHARSET(PASSTHRU, col )