23.10. The INFORMATION_SCHEMA COLLATIONS Table
The COLLATIONS table provides information about
collations for each character set.
The following statements are equivalent:
SELECT COLLATION_NAME FROM INFORMATION_SCHEMA.COLLATIONS
[WHERE collation_name LIKE 'wild']
SHOW COLLATION
[LIKE 'wild']
