D.5. RDB$COLLATIONS
RDB$COLLATIONS stores collation sequences for all character sets.
| Column Name | Data Type | Description |
|---|---|---|
|
| Collation sequence name |
|
| Collation sequence identifier. Together with the character set identifier, it is a unique collation sequence identifier |
|
| Character set identifier. Together with the collection sequence identifier, it is a unique identifier |
|
| 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 |
|
| Flag: the value of 0 means it is user-defined; the value of 1 means it is system-defined |
|
| Could store text description of the collation sequence |
|
| Not currently used |
|
| The name of the base collation sequence for this collation sequence |
|
| Describes specific attributes |
|
| May reference a security class defined in the table |
|
| The username of the user who created the collation originally |