九乡新闻网集安王忠平妻子图片:MySQL5.5 中文无法输入问题解决
来源：百度文库 编辑：九乡新闻网 时间：2024/05/06 02:55:32
mysql> status; //查看数据库状态
--------------
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时，则需设置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，此时，已可以向数据库输入中文！