Purpose
The information_schema.COLLATIONS view displays the collation of each character set.
Note
This view is introduced since OceanBase Database V1.4.
Columns
| Column | Type | Nullable? | |
|---|---|---|---|
| COLLATION_NAME | varchar(128) | NO | The name of the collation. |
| CHARACTER_SET_NAME | varchar(128) | NO | The name of the character set associated with the collation. |
| ID | bigint(20) | NO | The ID of the collation. |
| 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. |