javaweb数据库安插中文乱码

javaweb数据库插入中文乱码

在javaweb向数据库插入中文字符时,会出现乱码问题.原因是你的mysql数据库的character_set_client与character_set_server 的两个字符集属性不是utf-8等支持中文的字符集.在mysql命令框输入

show variables like 'character_set_%';

 你就可以看到相关属性如:

+--------------------------+-----------------------------------------------------------------+
| Variable_name            | Value                                                           |
+--------------------------+-----------------------------------------------------------------+
| character_set_client     | utf8                                                            |
| character_set_connection | utf8                                                            |
| character_set_database   | latin1                                                          |
| character_set_filesystem | binary                                                          |
| character_set_results    | utf8                                                            |
| character_set_server     | utf8                                                            |
| character_set_system     | utf8                                                            |
| character_sets_dir       | E:\Development Tools\wamp\bin\mysql\mysql5.5.20\share\charsets\ |
+--------------------------+-----------------------------------------------------------------+

 如果你的不为utf-8,可以去mysql的安装根目录下找到my.ini文件,在[cilent]下面添加

character_set_server = utf8

在[mysqld]下面添加

character_set_server = utf8

 请注意修改好之后,请重新起动mysql数据库服务;

然后再查看下是否已经修改好.