mysql show character_MySQL的show character set命令

show character set

显示MySQL当前支持哪些字符集，如下：mysql> show character set;

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

| Charset  | Description                     | Default collation   | Maxlen |

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

| big5     | Big5 Traditional Chinese        | big5_chinese_ci     |      2 |

| hp8      | HP West European                | hp8_english_ci      |      1 |

| koi8r    | KOI8-R Relcom Russian           | koi8r_general_ci    |      1 |

| latin1   | cp1252 West European            | latin1_swedish_ci   |      1 |

| latin2   | ISO 8859-2 Central European     | latin2_general_ci   |      1 |

| swe7     | 7bit Swedish                    | swe7_swedish_ci     |      1 |

| armscii8 | ARMSCII-8 Armenian              | armscii8_general_ci |      1 |

| utf8     | UTF-8 Unicode                   | utf8_general_ci     |      3 |

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

41 rows in set

我们还可以使用“like”进行过滤。如下：mysql> show character set like '%utf%';

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

| Charset | Description      | Default collation  | Maxlen |

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

| utf8    | UTF-8 Unicode    | utf8_general_ci    |      3 |

| utf8mb4 | UTF-8 Unicode    | utf8mb4_general_ci |      4 |

| utf16   | UTF-16 Unicode   | utf16_general_ci   |      4 |

| utf16le | UTF-16LE Unicode | utf16le_general_ci |      4 |

| utf32   | UTF-32 Unicode   | utf32_general_ci   |      4 |

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

5 rows in set