The CHARACTER_SETS view contains one row for every CCSID supported. The following table describes the columns in the view:
Column Name | Data Type | Description |
---|---|---|
CHARACTER_SET_CATALOG | VARCHAR(128) | Relational database name |
CHARACTER_SET_SCHEMA | VARCHAR(128) | The schema name of the character set. Contains 'SYSIBM'. |
CHARACTER_SET_NAME | VARCHAR(128) | The character set name. |
FORM_OF_USE | VARCHAR(128)
Nullable |
Reserved. Contains the null value. |
NUMBER_OF_CHARACTERS | INTEGER
Nullable |
Reserved. Contains the null value. |
DEFAULT_COLLATE_CATALOG | VARCHAR(128) | Reserved. Contains the relational database name. |
DEFAULT_COLLATE_SCHEMA | VARCHAR(128) | Reserved. Contains SYSIBM. |
DEFAULT_COLLATE_NAME | VARCHAR(128) | Reserved. Contains IBMDEFAULT. |
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.