mysql> status; //查看数据库状态--------------c:/wamp/bin/mysql/mysql5.5.8/bin/mysql.exe Ver 14.14 Distrib 5.5.8, for Win32 (x86)
Connection id: 2Current database:Current user: SSL: Not in useUsing delimiter: ;Server version: 5.5.8-log MySQL Community Server (GPL)Protocol version: 10Connection: localhost via TCP/IPServer characterset: latin1Db characterset: latin1Client characterset: gbkConn. characterset: gbkTCP port: 3306Uptime: 1 min 44 sec
Threads: 1 Questions: 16 Slow queries: 0 Opens: 35 Flush tables: 1 Open tables: 28 Queries per second avg: 0.153--------------
看到字符集是lantin1时,则需设置gbk后才能显示中文(不然显示将是一串??????)打开MySQL配置文件my.ini,随意找块空白贴上下面四行:
[client]default-character-set = gbk[mysqld]character-set-server = gbk
重启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: 3Current database:Current user: SSL: Not in useUsing delimiter: ;Server version: 5.5.8-log MySQL Community Server (GPL)Protocol version: 10Connection: localhost via TCP/IPServer characterset: gbkDb characterset: gbkClient characterset: gbkConn. characterset: gbkTCP port: 3306Uptime: 6 min 10 sec
Threads: 1 Questions: 19 Slow queries: 0 Opens: 35 Flush tables: 1 Open tables: 28 Queries per second avg: 0.51
--------------
OK,此时,已可以向数据库输入中文!
转载于:https://www.cnblogs.com/Gatsby/archive/2013/04/26/3045078.html
相关资源:DirectX修复工具V4.0增强版