my.cnf  [client] 
default-character-set=utf8 
[mysqld]  
character-set-server = utf8 

解决方案 »

  1.   

    把这个设置一下,看看是不是这个问题。客户端传输的时候 没用utf8 测试后  告诉一下我结果  
      

  2.   

    非常感谢你的回复,这个我在my.ini中设置了,查询字符集的结果如下:
    mysql> show variables like 'character_set_%';
    +--------------------------+------------------------------------------------+
    | 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       | E:\install\mysql-5.6.12-winx64\share\charsets\ |
    +--------------------------+------------------------------------------------+
    8 rows in set (0.00 sec)
    我直接用insert语句能够正常的写入中文,只是我调用存储过程时,VARCHAR(20)类型的参数需要在后面加上character set utf8 。
      

  3.   

    http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
    MySQL 中文显示乱码