怎么将mysql 的字符集该为gb2312或gbk

解决方案 »

  1.   

    在my.cnf 中修改,如下:
    [mysqld]
    port=3306
    #socket=MySQL
    skip-locking
    set-variable = key_buffer=16M
    set-variable = max_allowed_packet=1M
    set-variable = table_cache=64
    set-variable = sort_buffer=512K
    set-variable = net_buffer_length=8K
    set-variable = myisam_sort_buffer_size=8M
    server-id = 1
    default-character-set=gb2312 # 加這里就好了順便說一句,請您在以後提問時把問題寫在標題裡