插入中文报错：incorrect string value

Question

在插入中文时报“incorrect string value”，下面是编码配置的情况：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       | D:\MySQL Server 5.5\share\charsets\ |
+--------------------------+-------------------------------------+mysql> show create database mydb;
+-----------+--------------------------------------------------------------------+
| Database  | Create Database |
+-----------+--------------------------------------------------------------------+
| mydb      | CREATE DATABASE `mydb` /*!40100 DEFAULT CHARACTER SET utf8 */ |
+-----------+--------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> show create table test;
+-------+-------------------------------------------------------------------------------------------+
| Table | Create Table                    |
+-------+-------------------------------------------------------------------------------------------+
| test  | CREATE TABLE `test` (
  `s` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+-------+-------------------------------------------------------------------------------------------+请问该如何处理，谢谢！

Answer 1

set names 'gbk';
insert into test values ('请问');
select * from test;设置字符集后再试。http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL 中文显示乱码