(mysql.info.gz) CHARACTER_SETS Table
Info Catalog
(mysql.info.gz) COLUMN_PRIVILEGES Table
(mysql.info.gz) INFORMATION_SCHEMA Tables
(mysql.info.gz) COLLATIONS Table
21.1.9 The `INFORMATION_SCHEMA CHARACTER_SETS' Table
----------------------------------------------------
The `CHARACTER_SETS' table provides information about available
character sets.
*Standard Name* *`SHOW' name* *Remarks*
`CHARACTER_SET_CATALOG' omit
`CHARACTER_SET_SCHEMA' omit
`CHARACTER_SET_NAME' `Charset'
`CHARACTER_REPERTOIRE' omit
`FORM_OF_USE' omit
`NUMBER_OF_CHARACTERS' omit
`DEFAULT_COLLATE_CATALOG' omit
`DEFAULT_COLLATE_SCHEMA' omit
`DEFAULT_COLLATE_NAME' `Default collation'
`DESCRIPION' `Description' MySQL extension
`MAXLEN' `Maxlen' MySQL extension
Notes:
* We have added two non-standard columns corresponding to the
`Description' and `Maxlen' columns in the output from `SHOW
CHARACTER SET'.
The following statements are equivalent:
SELECT * FROM INFORMATION_SCHEMA.CHARACTER_SETS
[WHERE name LIKE 'wild']
SHOW CHARACTER SET
[LIKE 'wild']
Info Catalog
(mysql.info.gz) COLUMN_PRIVILEGES Table
(mysql.info.gz) INFORMATION_SCHEMA Tables
(mysql.info.gz) COLLATIONS Table
automatically generated byinfo2html