mysql 插入中文乱码，排查方法

错误信息：
ERROR 1366 (HY000): Incorrect string value: '\xB9\xD8\xD3\xF0' for column '

show variables where variable_name 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.0\share\charsets\ |
+--------------------------+---------------------------------------------------------+

保证为utf8
| character_set_filesystem | binary  这个值的信息不用管。

查看表的默认字符集为utf8;
修改字符类型的字段charset为utf8 与Collation为 utf8_general_ci。