The COLLATIONS table provides information about
collations for each character set.
INFORMATION_SCHEMA
Name
|
SHOW Name
|
Remarks |
COLLATION_NAME
|
Collation
|
|
CHARACTER_SET_NAME
|
Charset
|
MySQL extension |
ID
|
Id
|
MySQL extension |
IS_DEFAULT
|
Default
|
MySQL extension |
IS_COMPILED
|
Compiled
|
MySQL extension |
SORTLEN
|
Sortlen
|
MySQL extension |
The following statements are equivalent:
SELECT COLLATION_NAME FROM INFORMATION_SCHEMA.COLLATIONS [WHERE collation_name LIKE 'wild'] SHOW COLLATION [LIKE 'wild']