D.5 RDB$COLLATIONS

RDB$COLLATIONS stores collation sequences for all character sets.

Column Name Data Type Description
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