日期:2014-05-17  浏览次数:20821 次

MySql中文编码问题!! 求指教
jsp页面中编码设置成Charset=utf-8,mysql数据库中default-character-set=utf8
现在插入记录时报Incorrect string value(错误的字符串值);
截了图,求帮忙是哪里错了......

mysql> show variables like "%colla%";
+----------------------+-----------------+
| Variable_name        | Value           |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database   | utf8_general_ci |
| collation_server     | utf8_general_ci |
+----------------------+-----------------+
3 rows in set (0.00 sec)

mysql> show variables like "%char%";
+--------------------------+----------------------------------------------------
-----+
| 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
     |
| character_sets_dir       | C:\Program Files\MySQL\MySQL Server 5.5\share\chars
ets\ |
+--------------------------+----------------------------------------------------
-----+
8 rows in set (0.00 sec)



------解决方案--------------------
引用:
Quote: 引用:

Quote: 引用:

User类中name属性设置的是String类型啊! 数据库中用的是varchar类型,结果查数据的时候