The RDB$COLLATIONS system table describes the collating sequence
to be used in the database. The following table provides
information on the columns of the RDB$COLLATIONS system table.
Data
Column Name Type Summary Description
RDB$COLLATION_NAME char(31) Supplies the name by which
the database's collating
sequences are known within
the database.
RDB$COLLATION_SEQUENCE list Internal representation of
of byte the collating sequence.
varying
RDB$DESCRIPTION list A user-supplied description
of byte of the collating sequence.
varying
RDB$FLAGS integer A bit mask where the
following bits are set:
o Bit 0
If an ASCII collating
sequence.
o Bit 1
If a DEC_MCS collating
sequence.
RDB$SECURITY_CLASS char(20) Reserved for future use.
RDB$CREATED date vms Set when the collating
sequence is created.
RDB$LAST_ALTERED date vms Reserved for future use.
RDB$COLLATION_CREATOR char(31) Creator of this collating
sequence.