(mysql.info.gz) SHOW COLLATION

Info Catalog

(mysql.info.gz) SHOW CHARACTER SET

(mysql.info.gz) SHOW

(mysql.info.gz) SHOW COLUMNS

 
 13.5.4.2 `SHOW COLLATION' Syntax
 ................................
 
      SHOW COLLATION [LIKE 'PATTERN']
 
 The output from `SHOW COLLATION' includes all available character sets.
 It takes an optional `LIKE' clause that indicates which collation names
 to match. For example:
 
      mysql> SHOW COLLATION LIKE 'latin1%';
      +-------------------+---------+----+---------+----------+---------+
      | Collation         | Charset | Id | Default | Compiled | Sortlen |
      +-------------------+---------+----+---------+----------+---------+
      | latin1_german1_ci | latin1  |  5 |         |          |       0 |
      | latin1_swedish_ci | latin1  |  8 | Yes     | Yes      |       0 |
      | latin1_danish_ci  | latin1  | 15 |         |          |       0 |
      | latin1_german2_ci | latin1  | 31 |         | Yes      |       2 |
      | latin1_bin        | latin1  | 47 |         | Yes      |       0 |
      | latin1_general_ci | latin1  | 48 |         |          |       0 |
      | latin1_general_cs | latin1  | 49 |         |          |       0 |
      | latin1_spanish_ci | latin1  | 94 |         |          |       0 |
      +-------------------+---------+----+---------+----------+---------+
 
 The `Default' column indicates whether a collation is the default for
 its character set.  `Compiled' indicates whether the character set is
 compiled into the server.  `Sortlen' is related to the amount of memory
 required to sort strings expressed in the character set.
 
 `SHOW COLLATION' is available as of MySQL 4.1.0.
 

Info Catalog

(mysql.info.gz) SHOW CHARACTER SET

(mysql.info.gz) SHOW

(mysql.info.gz) SHOW COLUMNS