RDB$COLLATIONS

Go Up to System Tables

RDB$COLLATIONS records the valid collating sequences available for use in InterBase.

Column name	Data type	Length	Description
RDB$COLLATION_NAME	CHAR	67	Name of a valid collation sequence in InterBase.
RDB$COLLATION_ID	SMALLINT		Unique identifier for the collation sequence.
RDB$CHARACTER_SET_ID	SMALLINT		Identifier of the underlying character set of this collation sequence. Required before collation can proceed. Determines which character set is in use Corresponds to the RDB$CHARACTER_SET_ID column in the ­RDB$CHARACTER_SETS table.
RDB$COLLATION_ATTRIBUTES	SMALLINT		Reserved for internal use.
RDB$SYSTEM_FLAG	SMALLINT		Indicates whether the generator is: User-defined (value of 0). System-defined (value greater than 0).
RDB$DESCRIPTION	BLOB		Subtype Text: Contains a user-written description of the collation sequence.
RDB$FUNCTION_NAME	CHAR	67	Reserved for internal use.