The COLLATIONS view contains details about the collations available for each character set.
| Column | Description |
|---|---|
COLLATION_NAME |
The name of the collation. |
CHARACTER_SET_NAME |
The character set associated with the collation. |
ID |
The unique identifier for the collation. |
IS_DEFAULT |
Indicates whether the collation is the default for its character set. |
IS_COMPILED |
Indicates whether the character set is compiled into the server. |
SORTLEN |
The amount of memory required to sort strings in this character set. |
PAD_ATTRIBUTE |
The collation pad attribute, which can be either NO PAD or PAD SPACE. This determines whether trailing spaces are treated as significant in string comparisons. |
For more information, see the MySQL documentation: The INFORMATION_SCHEMA COLLATIONS Table.