Feature
This view provides information about collations for each character set.
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| 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. |