+--------------------------+--------------------------+
| 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 | D:\MySql\share\charsets\ |
+--------------------------+--------------------------+
字符编码已经修改成utf8了。还是插入不了中文。用了set names 'utf8'也不行。求大神指点
| 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 | D:\MySql\share\charsets\ |
+--------------------------+--------------------------+
字符编码已经修改成utf8了。还是插入不了中文。用了set names 'utf8'也不行。求大神指点
show full columns from table 看看所有字段的编码!
然后再试。