linux下查询MySQL中文数据乱码

使用select查询表，返回结果集，里面的中文全都是？？？？？？

处理步骤：

1、先看看当前的字符集

mysql> show variables like 'character_set_%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | latin1                     |
| character_set_connection | latin1                     |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | latin1                     |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+

2、设置字符集

mysql> set names 'utf8';
Query OK, 0 rows affected (0.00 sec)

它相当于下面的三句指令：
SET character_set_client = utf8;
SET character_set_results = utf8;
SET character_set_connection = utf8;

重新执行sql，中文不再乱了！