VMS Help  —  SQL72  System Tables, RDB$COLLATIONS
    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.
Close Help