3.30 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 [, ...]) 
character_set

Any supported character set.

column

The name of a column. To specify multiple columns, create a comma-delimited list.

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 )