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. |