MySQL中文乱码，phpmyadmin乱码，php乱码产生原因及其解决方法

您当前所在位置：首页 → 数据库 → MYSQL → MySQL中文乱码，phpmyadmin乱码，php乱码产生原因及其解决方法

MySQL中文乱码，phpmyadmin乱码，php乱码产生原因及其解决方法 时间：2015/6/28来源：IT猫扑网作者：网管联盟我要评论(0): 近日发现很多人为mysql中文乱码问题所困扰。于是就这个问题做一下浅析。不正确的地方希望大家指正

/*
来源 phpfans
网址:https://www.phpfans.net
*/

乱码产生原因

mysql字符编码是版本4.1引入的,支持多国语言,而且一些特性已经超过了其他的数据库系统。

我们可以在MySQL Command Line Client 下输入如下命令查看mysql的字符集

mysql> SHOW CHARACTER SET;
+----------+-----------------------------+---------------------+--------+
| Charset  | Description                | Default collation | Maxlen |
+----------+-----------------------------+---------------------+--------+
| big5    | Big5 Traditional Chinese | big5_chinese_ci    | 2    |
| dec8    | DEC West European          | dec8_swedish_ci    | 1    |
| cp850 | DOS West European          | cp850_general_ci | 1    |
| 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    |
| ascii | US ASCII                   | ascii_general_ci | 1    |
| ujis    | EUC-JP Japanese          | ujis_japanese_ci | 3    |
| sjis    | Shift-JIS Japanese       | sjis_japanese_ci | 2    |
| hebrew | ISO 8859-8 Hebrew          | hebrew_general_ci | 1    |
| tis620 | TIS620 Thai                | tis620_thai_ci    | 1    |
| euckr | EUC-KR Korean             | euckr_korean_ci    | 2    |
| koi8u | KOI8-U Ukrainian          | koi8u_general_ci | 1    |
| gb2312 | GB2312 Simplified Chinese | gb2312_chinese_ci | 2    |
| greek | ISO 8859-7 Greek          | greek_general_ci | 1    |
| cp1250 | Windows Central European | cp1250_general_ci | 1    |
| gbk    | GBK Simplified Chinese    | gbk_chinese_ci    | 2    |
| latin5 | ISO 8859-9 Turkish       | latin5_turkish_ci | 1    |
| armscii8 | ARMSCII-8 Armenian       | armscii8_general_ci | 1    |
| utf8    | UTF-8 Unicode             | utf8_general_ci    | 3    |
| ucs2    | UCS-2 Unicode             | ucs2_general_ci    | 2    |
| cp866 | DOS Russian                | cp866_general_ci | 1    |
| keybcs2  | DOS Kamenicky Czech-Slovak  | keybcs2_general_ci  | 1    |
| macce | Mac Central European       | macce_general_ci | 1    |
| macroman | Mac West European          | macroman_general_ci | 1    |
| cp852 | DOS Central European       | cp852_general_ci | 1    |
| latin7 | ISO 8859-13 Baltic       | latin7_general_ci | 1    |
| cp1251 | Windows Cyrillic          | cp1251_general_ci | 1    |
| cp1256 | Windows Arabic             | cp1256_general_ci | 1    |
| cp1257 | Windows Baltic             | cp1257_general_ci | 1    |
| binary | Binary pseudo charset    | binary             | 1    |
| geostd8  | GEOSTD8 Georgian          | geostd8_general_ci  | 1    |
| cp932 | SJIS for Windows Japanese | cp932_japanese_ci | 2    |
| eucjpms  | UJIS for Windows Japanese | eucjpms_japanese_ci | 3    |
+----------+-----------------------------+---------------------+--------+
36 rows in set (0.02 sec)

更多mysql的字符集知识可以参考https://www.phpfans.net论坛的
https://www.phpfans.net/bbs/viewthread.php?tid=296&extra=page%3D1
或者mysql官方的
https://dev.mysql.com/doc/refman/5.1/zh/charset.html

MySQL 4.1的字符集支持(Character Set Support)有两个方面：字符集(Character set)和排序方式(Collation)。对于字符集的支持细化到四个层次: 服务器(server)，数据库(database)，数据表(table)和连接(connection)。
查看系统的字符集和排序方式的设定可以通过下面的两条命令：

mysql> SHOW VARIABLES LIKE 'character_set_%';
+--------------------------+-------------------------------------------+
| Variable_name          | Value                                  |
+--------------------------+-------------------------------------------+
| character_set_client    | latin1                                  |
| character_set_
关键词标签：及其,解决,原因,方法,