D.3. RDB$CHARACTER_SETS

RDB$CHARACTER_SETS names and describes the character sets available in the database.

Column NameData TypeDescription

RDB$CHARACTER_SET_NAME

CHAR(31)

Character set name

RDB$FORM_OF_USE

CHAR(31)

Not used

RDB$NUMBER_OF_CHARACTERS

INTEGER

The number of characters in the set. Not used for existing character sets

RDB$DEFAULT_COLLATE_NAME

CHAR(31)

The name of the default collation sequence for the character set

RDB$CHARACTER_SET_ID

SMALLINT

Unique character set identifier

RDB$SYSTEM_FLAG

SMALLINT

System flag: value is 1 if the character set is defined in the system when the database is created; value is 0 for a user-defined character set

RDB$DESCRIPTION

BLOB TEXT

Could store text description of the character set

RDB$FUNCTION_NAME

CHAR(31)

For a user-defined character set that is accessed via an external function, the name of the external function

RDB$BYTES_PER_CHARACTER

SMALLINT

The maximum number of bytes representing one character

RDB$SECURITY_CLASS

CHAR(31)

May reference a security class defined in the table RDB$SECURITY_CLASSES, in order to apply access control limits to all users of this character set

RDB$OWNER_NAME

CHAR(31)

The user name of the user who created the character set originally