为什么可以插入英文却不能插入汉字!!!!!我设成utf8却可以,可惜我设成gbk与gb2312都是设不好,只能插入E文,汉字进不了数据库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 | F:\mysql\share\charsets\ |
+--------------------------+--------------------------+
+--------------------------+--------------------------+
| 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 | F:\mysql\share\charsets\ |
+--------------------------+--------------------------+
这是在安装MySQL时没有选择字符集引起的.以5.0为例,点开始菜单找到MySQL
选择MySQL Server5.0 选择MySQL Server Instance Config Wizard 一直点击下一步,到选择字符集的时候 选择gbk 或者 gb2312 然后选择最下面的选项(Manual Selected Default Character Set/Collation) Character Set:gbk 然后就点下一步就ok了 希望你能成功