COLLATIONS
The COLLATIONS system view describes each collation to which the current ident, or PUBLIC, has USAGE privilege.
The view includes one row describing the collation named SQL_TEXT which is defined on the character set named SQL_TEXT and is the default collation for that character set.
Column name
|
Data type
|
Description
|
| COLLATION_CAT |
VARCHAR(128) |
The name of the catalog containing the collation. |
| COLLATION_SCHEM |
VARCHAR(128) |
The name of the schema containing the collation. |
| COLLATION_NAME |
VARCHAR(128) |
Name of the collation. |
| CHARSET_CAT |
VARCHAR(128) |
The name of the catalog containing the character set on which the collation is defined. |
| CHARSET_SCHEM |
VARCHAR(128) |
The name of the schema containing the character set on which the collation is defined. |
| CHARSET_NAME |
VARCHAR(128) |
The name of the character set on which the collation is defined. |
| PAD_ATTRIBUTE |
VARCHAR(20) |
One of the following values:
"NO PAD" = the collation has the no pad attribute
"PAD SPACE" = the collation has the pad space attribute. |
| REMARKS |
VARCHAR(254) |
May contain descriptive information about the collation. |
