mysql无法插入中文

Question

+--------------------------+--------------------------+
| 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'也不行。求大神指点

Answer 1

show  full columns from  table  看看所有字段的编码！

Answer 2

所有字段都是utf8的

Answer 3

所有字段都是utf8的

Answer 4

set names 'gbk';
然后再试。

Answer 5

建立字符集是gbk的表

Answer 6

建议简历gbk编码的表！