MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0

25.4 The INFORMATION_SCHEMA COLLATIONS Table

The COLLATIONS table provides information about collations for each character set.

The COLLATIONS table has these columns:

Notes

Collation information is also available from the SHOW COLLATION statement. See Section 13.7.7.4, “SHOW COLLATION Syntax”. The following statements are equivalent:

SELECT COLLATION_NAME FROM INFORMATION_SCHEMA.COLLATIONS
  [WHERE COLLATION_NAME LIKE 'wild']

SHOW COLLATION
  [LIKE 'wild']