(mysql.info.gz) COLLATION_CHARACTER_SET_APPLICABILITY Table

Info Catalog

(mysql.info.gz) COLLATIONS Table

(mysql.info.gz) INFORMATION_SCHEMA Tables

(mysql.info.gz) TABLE_CONSTRAINTS Table

 
 21.1.11 The `INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY' Table
 ----------------------------------------------------------------------------
 
 The `COLLATION_CHARACTER_SET_APPLICABILITY' table indicates what
 character set is applicable for what collation. The columns are
 equivalent to the first two display fields that we get from `SHOW
 COLLATION'.
 
 *Standard Name*               *`SHOW' name*          *Remarks*
 `COLLATION_CATALOG'                                  omit
 `COLLATION_SCHEMA'                                   omit
 `COLLATION_NAME'              `Collation'            
 `CHARACTER_SET_CATALOG'                              omit
 `CHARACTER_SET_SCHEMA'                               omit
 `CHARACTER_SET_NAME'          `Charset'              
 

Info Catalog

(mysql.info.gz) COLLATIONS Table

(mysql.info.gz) INFORMATION_SCHEMA Tables

(mysql.info.gz) TABLE_CONSTRAINTS Table