Firebird 2.5 Language ReferenceFirebird 2.5 Language ReferenceSystem Tables → RDB$COLLATIONS
Firebird Firebird Prev: RDB$CHECK_CONSTRAINTSFirebird 2.5 Language ReferenceUp: System TablesNext: RDB$DATABASE

RDB$COLLATIONS

RDB$COLLATIONS stores collation sequences for all character sets.

Column Name Data Type Description
RDB$COLLATION_NAME CHAR(31) 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(31) Not currently used
RDB$BASE_COLLATION_NAME CHAR(31) The name of the base collation sequence for this collation sequence
RDB$SPECIFIC_ATTRIBUTES BLOB TEXT Describes specific attributes

Prev: RDB$CHECK_CONSTRAINTSFirebird 2.5 Language ReferenceUp: System TablesNext: RDB$DATABASE
Firebird 2.5 Language ReferenceFirebird 2.5 Language ReferenceSystem Tables → RDB$COLLATIONS