MySQL5中文乱码解决关键字: mysql5中文乱码解决MySql5中文乱码的解决方法在使用MYSQL时，插入中文字符，经常会出现乱码，中文全被用?代替。出现这种情况的原因，多是字符集不匹配造成的。
在MYSQL中，如果使用缺省的字符集，在建库、建表时，默认使用的是latin1字符集，为ISO 8859-1西欧字符集。插入中文字符时，与之不匹配，就会出现乱码。 要解决此问题，就必须手动将数据库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(以前建立的数据库要重建),运行MySQL Command Line Client： 输入show variables like 'character_set_%';可以查看数据库的字符编码如下： 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时,例： set character_set_database=gbk; 然后，在程序中将连接数据库的URL改为jdbc:mysql://localhost:3306/databasename?useUnicode=true&characterEncoding=gb2312就可以了！ 当然要支持国际化最好把以上所有gb2312换成utf8（注意不是utf-8，除了 在程序中将连接数据库的URL改为jdbc:mysql://localhost:3306/databasename?useUnicode=true&characterEncoding=utf-8） |
|
|
