//经常遇到的显示乱码如下:
mysql> select * from admininfo;
+-------+-------+-------+--------+
| Aid | Aname | Apwd | Alevel |
+-------+-------+-------+--------+
| 10001 | zrk | 12345 | 瓒呯骇 |
| 10002 | cgq | 12345 | 鏅€? |
| 10003 | hxl | 12345 | 鏅€? |
+-------+-------+-------+--------+
3 rows in set (0.00 sec)
//可以这样解决:
mysql> set names gbk;
Query OK, 0 rows affected (0.00 sec)
//正确显示:
mysql> select * from admininfo;
+-------+-------+-------+--------+
| Aid | Aname | Apwd | Alevel |
+-------+-------+-------+--------+
| 10001 | zrk | 12345 | 超级
| 10002 | cgq | 12345 | 普通
| 10003 | hxl | 12345 | 普通
+-------+-------+-------+--------+
3 rows in set (0.00 sec)