MYSQL windows 命令行乱码

1. windows 命令行目前不支持utf-8,可以使用cygwin模拟linux shell来做到。

[url]http://zsp.iteye.com/blog/173067[/url]

2. 可以切换mysql shell连接编码为gbk.

mysql>set names gbk;

mysql>status

Connection: localhost via TCP/IP
Server characterset: utf8
Db characterset: utf8
Client characterset: gbk
Conn. characterset: gbk

mysql> select * from example;
+------+-----------+
| id | data |
+------+-----------+
| 1 | test1 |
| 2 | test2测试 |
| 3 | test3测试 |
+------+-----------+
3 rows in set (0.00 sec)