The output from SHOW COLLATION includes all available character sets. : COLLATION Character Set : Table MySQL TUTORIALS


MySQL TUTORIALS » Table » COLLATION Character Set »

 

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>
mysql> SHOW COLLATION LIKE 'latin1%';
+-------------------+---------+----+---------+----------+---------+
| Collation         | Charset | Id | Default | Compiled | Sortlen |
+-------------------+---------+----+---------+----------+---------+
| latin1_german1_ci | latin1  |  |         | Yes      |       |
| latin1_swedish_ci | latin1  |  | Yes     | Yes      |       |
| latin1_danish_ci  | latin1  | 15 |         | Yes      |       |
| latin1_german2_ci | latin1  | 31 |         | Yes      |       |
| latin1_bin        | latin1  | 47 |         | Yes      |       |
| latin1_general_ci | latin1  | 48 |         | Yes      |       |
| latin1_general_cs | latin1  | 49 |         | Yes      |       |
| latin1_spanish_ci | latin1  | 94 |         | Yes      |       |
+-------------------+---------+----+---------+----------+---------+
rows in set (0.00 sec)



Leave a Comment / Note


 
Verification is used to prevent unwanted posts (spam). .

Follow Navioo On Twitter

MySQL TUTORIALS

 Navioo Table
» COLLATION Character Set