问题描述:
我在JSP页面中使用的字符集是:utf-8,MySQL数据库字符设置如下:
variable_name | value |
+--------------------------+---------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8
variable_name | value |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+----------------------+-----------------+提交到数据库中如果有中文,则会出现乱码。如果直接在MySQL的DOS中使用Insert语句插入数据(其中有中文),报错:
ERROR:1366<HY000> incorrect string value .......
另外,我使用MySQL的DOS修改字符集时,提示utf8不对,我改成utf8_chinese_ci也一样:
mysql> set collation_connection = utf8 ;
mysql> set collation_database = utf8 ;
mysql> set collation_server = utf8 ;求高人指教,谢谢!!!!!
我在JSP页面中使用的字符集是:utf-8,MySQL数据库字符设置如下:
variable_name | value |
+--------------------------+---------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8
variable_name | value |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+----------------------+-----------------+提交到数据库中如果有中文,则会出现乱码。如果直接在MySQL的DOS中使用Insert语句插入数据(其中有中文),报错:
ERROR:1366<HY000> incorrect string value .......
另外,我使用MySQL的DOS修改字符集时,提示utf8不对,我改成utf8_chinese_ci也一样:
mysql> set collation_connection = utf8 ;
mysql> set collation_database = utf8 ;
mysql> set collation_server = utf8 ;求高人指教,谢谢!!!!!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货