The CHARACTER_SETS view contains details about the available character sets.
| Column | Description |
|---|---|
CHARACTER_SET_NAME |
The name of the character set. |
DEFAULT_COLLATE_NAME |
The default collation associated with the character set. |
DESCRIPTION |
A brief description of the character set. |
MAXLEN |
The maximum number of bytes needed to store a single character. |
For more information, see the MySQL documentation: The INFORMATION_SCHEMA CHARACTER_SETS Table.