mysql> status; //查看數(shù)據(jù)庫(kù)狀態(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í)，則需設(shè)置gbk后才能顯示中文（不然顯示將是一串??????）
打開(kāi)MySQL配置文件my.ini，隨意找塊空白貼上下面四行：
[client]
default-character-set = gbk
[mysqld]
character-set-server = gbk
collation-server = utf8_general_ci
重啟mysql，進(jìn)入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í)，已可以向數(shù)據(jù)庫(kù)輸入中文！
