D.5 RDB$COLLATIONS

RDB$COLLATIONS stores collation sequences for all character sets.

Column NameData TypeDescription

RDB$COLLATION_NAME

CHAR(63)

Collation sequence name

RDB$COLLATION_ID

SMALLINT

Collation sequence identifier. Together with the character set identifier, it is a unique collation sequence identifier

RDB$CHARACTER_SET_ID

SMALLINT

Character set identifier. Together with the collection sequence identifier, it is a unique identifier

RDB$COLLATION_ATTRIBUTES

SMALLINT

Collation attributes. It is a bit mask where the first bit shows whether trailing spaces should be taken into account in collations (0 - NO PAD; 1 - PAD SPACE); the second bit shows whether the collation is case-sensitive (0 - CASE SENSITIVE, 1 - CASE INSENSITIVE); the third bit shows whether the collation is accent-sensitive (0 - ACCENT SENSITIVE, 1 - ACCENT SENSITIVE). Thus, the value of 5 means that the collation does not take into account trailing spaces and is accent-insensitive

RDB$SYSTEM_FLAG

SMALLINT

Flag: the value of 0 means it is user-defined; the value of 1 means it is system-defined

RDB$DESCRIPTION

BLOB TEXT

Could store text description of the collation sequence

RDB$FUNCTION_NAME

CHAR(63)

Not currently used

RDB$BASE_COLLATION_NAME

CHAR(63)

The name of the base collation sequence for this collation sequence

RDB$SPECIFIC_ATTRIBUTES

BLOB TEXT

Describes specific attributes

RDB$SECURITY_CLASS

CHAR(63)

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

RDB$OWNER_NAME

CHAR(63)

The user name of the user who created the collation originally