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数据库服务;
然后再查看下是否已经修改好.