mysql show collation_MySQL的show collation命令

show collation

显示MySQL支持字符集的排序规则。如下：mysql> show collation;

+--------------------------+----------+-----+---------+----------+---------+

| Collation                | Charset  | Id  | Default | Compiled | Sortlen |

+--------------------------+----------+-----+---------+----------+---------+

| big5_chinese_ci          | big5     |   1 | Yes     | Yes      |       1 |

| big5_bin                 | big5     |  84 |         | Yes      |       1 |

...

+--------------------------+----------+-----+---------+----------+---------+

222 rows in set (0.00 sec)

还可以使用“like”过滤排序规则。如下：mysql> show collation like '%utf8_ge%';

+--------------------------+---------+-----+---------+----------+---------+

| Collation                | Charset | Id  | Default | Compiled | Sortlen |

+--------------------------+---------+-----+---------+----------+---------+

| utf8_general_ci          | utf8    |  33 | Yes     | Yes      |       1 |

| utf8_german2_ci          | utf8    | 212 |         | Yes      |       8 |

| utf8_general_mysql500_ci | utf8    | 223 |         | Yes      |       1 |

+--------------------------+---------+-----+---------+----------+---------+

3 rows in set (0.00 sec)