20.1. The INFORMATION_SCHEMA CHARACTER_SETS Table

The CHARACTER_SETS table provides information about available character sets.

The following statements are equivalent:

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