MySQL中文乱码.doc

MySQL 不要放弃自己! ------- (妈妈曾经这样对我说,转身出门的一刹那, 我泪流满面,却不想让任何人看见!) 看到这一句小编也心有感触,想起当初离家前往几千里外的地方的时候,妈妈也说过类似的话,但是身为男儿,必须创出一片天,才能报答父母的养育之恩!! 乱码产生原因 mysql 字符编码是版本 引入的, 支持多国语言, 而且一些特性已经超过了其他的数据库系统。我们可以在 mand 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 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 |