CHARACTER_SETS

The CHARACTER_SETS view contains one row for every CCSID supported.

The following table describes the columns in the view:

Table 1. CHARACTER_SETS 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.