關(guān)鍵字: mysql5中文亂碼解決
MySql5中文亂碼的解決方法在使用MYSQL時(shí)，插入中文字符，經(jīng)常會(huì)出現(xiàn)亂碼，中文全被用?代替。出現(xiàn)這種情況的原因，多是字符集不匹配造成的。
在MYSQL中，如果使用缺省的字符集，在建庫、建表時(shí)，默認(rèn)使用的是latin1字符集，為ISO 8859-1西歐字符集。插入中文字符時(shí)，與之不匹配，就會(huì)出現(xiàn)亂碼。
要解決此問題，就必須手動(dòng)將數(shù)據(jù)庫Server和Client的字符編碼改為gb2312。配置方法如下：
打開MYSQL安裝目錄下的my.ini文件，找到如下段落：
# CLIENT SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by MySQL client applications.
# Note that only client applications shipped by MySQL are guaranteed
# to read this section. If you want your own MySQL client program to
# honor these values, you need to specify it as an option during the
# MySQL client library initialization.
#
[client]
port=3306
[mysql]
default-character-set=latin1
# SERVER SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by the MySQL Server. Make sure that
# you have installed the server correctly (see above) so it reads this
# file.
#
[mysqld]
# The TCP/IP Port the MySQL Server will listen on
port=3306
#Path to installation directory. All paths are usually resolved relative to this.
basedir="D:/MySQL/MySQL Server 5.0/"
#Path to the database root
datadir="D:/MySQL/MySQL Server 5.0/Data/"
# The default character set that will be used when a new schema or table is
# created and no character set is defined
default-character-set=latin1
將其中的default-character-set=latin1改為default-character-set=gb2312,然后重啟MYSQL(以前建立的數(shù)據(jù)庫要重建),運(yùn)行MySQL Command Line Client：
輸入show variables like 'character_set_%';可以查看數(shù)據(jù)庫的字符編碼如下：
mysql> show variables like 'character_set_%';
+--------------------------+-----------------------------------------+
| Variable_name | Value |
+--------------------------+-----------------------------------------+
| character_set_client | gb2312 |
| character_set_connection | gb2312 |
| character_set_database | gb2312 |
| character_set_filesystem | binary |
| character_set_results | gb2312 |
| character_set_server | gb2312 |
| character_set_system | utf8 |
| character_sets_dir | D:\MySQL\MySQL Server 5.0\share\charsets|
+--------------------------+-----------------------------------------+
查出不是gbk時(shí),例： set character_set_database=gbk;
然后，在程序中將連接數(shù)據(jù)庫的URL改為jdbc:mysql://localhost:3306/databasename?useUnicode=true&characterEncoding=gb2312就可以了！
當(dāng)然要支持國際化最好把以上所有g(shù)b2312換成utf8（注意不是utf-8，除了
在程序中將連接數(shù)據(jù)庫的URL改為jdbc:mysql://localhost:3306/databasename?useUnicode=true&characterEncoding=utf-8）
