(mysql.info.gz) COLLATIONS Table
Info Catalog
(mysql.info.gz) CHARACTER_SETS Table
(mysql.info.gz) INFORMATION_SCHEMA Tables
(mysql.info.gz) COLLATION_CHARACTER_SET_APPLICABILITY Table
21.1.10 The `INFORMATION_SCHEMA COLLATIONS' Table
-------------------------------------------------
The `COLLATIONS' table provides information about collations for each
character set.
*Standard Name* *`SHOW' name* *Remarks*
`COLLATION_CATALOG' omit
`COLLATION_SCHEMA' omit
`COLLATION_NAME' `Collation'
`PAD_ATTRIBUTE' omit
`COLLATION_TYPE' omit
`COLLATION_DEFINITION' omit
`COLLATION_DICTIONARY' omit
`CHARACTER_SET_NAME' omit MySQL extension
`ID' omit MySQL extension
`IS_DEFAULT' omit MySQL extension
`IS_COMPILED' omit MySQL extension
`SORTLEN' omit MySQL extension
Notes:
* We have added five non-standard columns corresponding to the
`Charset', `Id', `Default', `Compiled', and `Sortlen' columns in
the output from `SHOW COLLATION'.
The following statements are equivalent:
SELECT COLLATION_NAME FROM INFORMATION_SCHEMA.COLLATIONS
[WHERE collation_name LIKE 'wild']
SHOW COLLATION
[LIKE 'wild']
Info Catalog
(mysql.info.gz) CHARACTER_SETS Table
(mysql.info.gz) INFORMATION_SCHEMA Tables
(mysql.info.gz) COLLATION_CHARACTER_SET_APPLICABILITY Table
automatically generated byinfo2html