(mysql.info) collations-table
Info Catalog
(mysql.info) character-sets-table
(mysql.info) information-schema
(mysql.info) collation-character-set-applicability-table
20.10 The `INFORMATION_SCHEMA COLLATIONS' Table
===============================================
The `COLLATIONS' table provides information about collations for each
character set.
*`INFORMATION_SCHEMA' Name* *`SHOW' Name* *Remarks*
`COLLATION_NAME' `Collation'
`CHARACTER_SET_NAME' `Charset' MySQL extension
`ID' `Id' MySQL extension
`IS_DEFAULT' `Default' MySQL extension
`IS_COMPILED' `Compiled' MySQL extension
`SORTLEN' `Sortlen' MySQL extension
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) character-sets-table
(mysql.info) information-schema
(mysql.info) collation-character-set-applicability-table
automatically generated byinfo2html