(mysql.info) charset-column

Info Catalog

(mysql.info) charset-table

(mysql.info) charset-syntax

(mysql.info) charset-literal

 
 10.3.4 Column Character Set and Collation
 -----------------------------------------
 
 Every `character' column (that is, a column of type `CHAR', `VARCHAR',
 or `TEXT') has a column character set and a column collation. Column
 definition syntax has optional clauses for specifying the column
 character set and collation:
 
      COL_NAME {CHAR | VARCHAR | TEXT} (COL_LENGTH)
          [CHARACTER SET CHARSET_NAME [COLLATE COLLATION_NAME]]
 
 Example:
 
      CREATE TABLE Table1
      (
          column1 VARCHAR(5) CHARACTER SET latin1 COLLATE latin1_german1_ci
      );
 
 MySQL chooses the column character set and collation in the following
 manner:
 
    * If both `CHARACTER SET X' and `COLLATE Y' were specified, then
      character set X and collation Y are used.
 
    * If `CHARACTER SET X' was specified without `COLLATE', then
      character set X and its default collation are used.
 
    * If `COLLATE Y' was specified without `CHARACTER SET', then the
      character set associated with Y and collation Y.
 
    * Otherwise, the table character set and collation are used.
 
 The `CHARACTER SET' and `COLLATE' clauses are standard SQL.
 

Info Catalog

(mysql.info) charset-table

(mysql.info) charset-syntax

(mysql.info) charset-literal