本文介绍了如何在Windows命令行环境下通过Cygwin模拟Linux shell来支持UTF-8编码，并详细说明了如何切换MySQL shell连接的字符集为gbk，包括设置编码、查看连接状态及执行SQL查询。
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)
[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)
扫一扫
1063
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
