Purpose
information_schema.COLLATIONS displays information about collations for each character set.
Related tables/views
__all_collation
Fields
| Field | 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 amount of memory required to sort strings expressed in the character set. |