Mega Code Archive

 

Categories / MySQL Tutorial / Table

 

The output from SHOW COLLATION includes all available character sets

It takes an optional LIKE clause that indicates which collation names to match. mysql> mysql> SHOW COLLATION LIKE 'latin1%'; +-------------------+---------+----+---------+----------+---------+ | Collation         | Charset | Id | Default | Compiled | Sortlen | +-------------------+---------+----+---------+----------+---------+ | latin1_german1_ci | latin1  |  5 |         | Yes      |       1 | | latin1_swedish_ci | latin1  |  8 | Yes     | Yes      |       1 | | latin1_danish_ci  | latin1  | 15 |         | Yes      |       1 | | latin1_german2_ci | latin1  | 31 |         | Yes      |       2 | | latin1_bin        | latin1  | 47 |         | Yes      |       1 | | latin1_general_ci | latin1  | 48 |         | Yes      |       1 | | latin1_general_cs | latin1  | 49 |         | Yes      |       1 | | latin1_spanish_ci | latin1  | 94 |         | Yes      |       1 | +-------------------+---------+----+---------+----------+---------+ 8 rows in set (0.00 sec)