The CHARACTER_SETS table provides information
about available character sets.
INFORMATION_SCHEMA
Name
|
SHOW Name
|
Remarks |
CHARACTER_SET_NAME
|
Charset
|
|
DEFAULT_COLLATE_NAME
|
Default collation
|
|
DESCRIPION
|
Description
|
MySQL extension |
MAXLEN
|
Maxlen
|
MySQL extension |
The following statements are equivalent:
SELECT * FROM INFORMATION_SCHEMA.CHARACTER_SETS [WHERE name LIKE 'wild'] SHOW CHARACTER SET [LIKE 'wild']