Purpose
The information_schema.COLLATIONS view provides information about collations for each character set.
Note
This view is introduced since OceanBase Database V1.4.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| COLLATION_NAME | varchar(128) | NO | The collation name. |
| CHARACTER_SET_NAME | varchar(128) | NO | The name of the character set with which the collation is associated. |
| ID | bigint(20) | NO | The collation ID. |
| IS_DEFAULT | varchar(4) | NO | Indicates whether the collation is the default collation for its character set. |
| IS_COMPILED | varchar(4) | NO | Indicates whether the character set is compiled into the server. |
| SORTLEN | bigint(20) | NO | The size of memory required to sort strings expressed in the character set. |