MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0

25.2 The INFORMATION_SCHEMA CHARACTER_SETS Table

The CHARACTER_SETS table provides information about available character sets.

The CHARACTER_SETS table has these columns:

Notes

Character set information is also available from the SHOW CHARACTER SET statement. See Section 13.7.6.3, “SHOW CHARACTER SET Syntax”. The following statements are equivalent:

SELECT * FROM INFORMATION_SCHEMA.CHARACTER_SETS
  [WHERE CHARACTER_SET_NAME LIKE 'wild']

SHOW CHARACTER SET
  [LIKE 'wild']