(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