SET character_set_server = gbk;SET collation_server = gbk_bin;

解决方案 »

  1.   


    改完后再次连接 mysql> mysql -u*** -p** ; SHOW VARIABLES LIKE "character_set_%";+--------------------------+--------------------------------------------------------------------------+
    | Variable_name            | Value                                                                    |
    +--------------------------+--------------------------------------------------------------------------+
    | character_set_client     | latin1                                                                   |
    | character_set_connection | latin1                                                                   |
    | character_set_database   | latin1                                                                   |
    | character_set_results    | latin1                                                                   |
    | character_set_server     | latin1 
    还是没改过来。只能对当前连接有效
      

  2.   

    只对当前连接有效,否则需要在my.ini中设置