(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