小男孩‘自慰网亚洲一区二区,亚洲一级在线播放毛片,亚洲中文字幕av每天更新,黄aⅴ永久免费无码,91成人午夜在线精品,色网站免费在线观看,亚洲欧洲wwwww在线观看

分享

MySQL5.5 中文無法輸入問題解決

 卓柏卡布拉 2011-08-25

mysql> status;        //查看數(shù)據(jù)庫狀態(tài)
--------------
c:/wamp/bin/mysql/mysql5.5.8/bin/mysql.exe  Ver 14.14 Distrib 5.5.8, for Win32 (
x86)

Connection id:          2
Current database:
Current user:           root@localhost
SSL:                    Not in use
Using delimiter:        ;
Server version:         5.5.8-log MySQL Community Server (GPL)
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    gbk
Conn.  characterset:    gbk
TCP port:               3306
Uptime:                 1 min 44 sec

Threads: 1  Questions: 16  Slow queries: 0  Opens: 35  Flush tables: 1  Open tab
les: 28  Queries per second avg: 0.153
--------------

 

 

看到字符集是lantin1時,則需設(shè)置gbk后才能顯示中文(不然顯示將是一串??????)
打開MySQL配置文件my.ini,隨意找塊空白貼上下面四行:

[client]
default-character-set = gbk
[mysqld]
character-set-server = gbk

collation-server     = utf8_general_ci

重啟mysql,進入mysql> status;  //再次查看

--------------
c:/wamp/bin/mysql/mysql5.5.8/bin/mysql.exe  Ver 14.14 Distrib 5.5.8, for Win32 (
x86)

Connection id:          3
Current database:
Current user:          root@localhost
SSL:                    Not in use
Using delimiter:        ;
Server version:         5.5.8-log MySQL Community Server (GPL)
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    gbk
Db     characterset:    gbk
Client characterset:    gbk
Conn.  characterset:    gbk
TCP port:               3306
Uptime:                 6 min 10 sec

Threads: 1  Questions: 19  Slow queries: 0  Opens: 35  Flush tables: 1  Open tab
les: 28  Queries per second avg: 0.51

--------------

OK,此時,已可以向數(shù)據(jù)庫輸入中文!


    本站是提供個人知識管理的網(wǎng)絡(luò)存儲空間,所有內(nèi)容均由用戶發(fā)布,不代表本站觀點。請注意甄別內(nèi)容中的聯(lián)系方式、誘導購買等信息,謹防詐騙。如發(fā)現(xiàn)有害或侵權(quán)內(nèi)容,請點擊一鍵舉報。
    轉(zhuǎn)藏 分享 獻花(0

    0條評論

    發(fā)表

    請遵守用戶 評論公約

    類似文章 更多