CHARACTER_SETS

Information on character sets available to the current authorization identifier.

Column name	Data type	Contents
CHARACTER_SET_CATALOG	CHAR (18)	Database name
CHARACTER_SET_SCHEMA	CHAR (31)	INFORMATION_SCHEMA
CHARACTER_SET_NAME	CHAR (18)	UTF16, EBCDIC, SQL_TEXT SQL_CHARACTER, SQL_IDENTIFIER
FORM_OF_USE	CHAR (18)	EBCDIC, UTF16
NUMBER_OF_CHARACTERS	INTEGER	With FORM_OF_USE= EBCDIC the number of characters in the character set, NULL value in all other cases
DEFAULT_COLLATE_CATALOG	CHAR (18)	Database name
DEFAULT_COLLATE_SCHEMA	CHAR (31)	INFORMATION_SCHEMA
DEFAULT_COLLATE_NAME	CHAR (18)	EBCDIC_BINARY UTF16_BINARY

Table 66: CHARACTER_SETS view of the INFORMATION_SCHEMA