Information Schema CHARACTER_SETS Table

The Information Schema CHARACTER_SETS table contains a list of supported character sets, their default collations and maximum lengths.

It contains the following columns:

The statement returns the same results (although in a different order), and both can be refined in the same way. For example, the following two statements return the same results:

and

See for details on specifying the character set at the server, database, table and column levels, and for a full list of supported characters sets and collations.

Example

_{This page is licensed: CC BY-SA / Gnu FDL}