又试验了下..只有全部使用default,才能正确输入中文..

解决方案 »

  1.   

    mysql数据库字符集设置成如下:
    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\share\charsets\ |
    +--------------------------+--------------------------+
    8 rows in set (0.20 sec)除了在dos界面输入中文会有乱码外,其余通过phpMyAdmin,mysql query browser,mysql front等输入中文都不会出现乱码,至于dos输入中文出现乱码是因为dos下面不支持utf8字符集的原因.