解决mysql中文问题

mysql> SHOW VARIABLES LIKE 'character_set_%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | gbk                        |
| character_set_connection | gbk                        |
| character_set_database   | latin1                     |
| character_set_filesystem | binary                     |
| character_set_results    | gbk                        |
| character_set_server     | latin1                     |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |

+--------------------------+----------------------------+

可以看到数据库的字符集是latin1

mysql> show create database ccse;
+----------+-----------------------------------------------------------------+
| Database | Create Database                                                 |
+----------+-----------------------------------------------------------------+
| ccse     | CREATE DATABASE `ccse` /*!40100 DEFAULT CHARACTER SET latin1 */ |
+----------+-----------------------------------------------------------------+

 $sudo gedit /etc/ mysql/my.cnf
[client]下添加：
 
default-character-set=utf8
character_set_client  

 [mysqld]下添加的应该为：
 
character-set-server=utf8
 
collation-server=utf8_general_ci
 
保存退出
 
$sudo service mysql restart
 
成功

最后, 最好的办法是在命令行下面执行

http://www.cnblogs.com/discuss/articles/1862248.html

如果实在不行:

http://guichina.blog.51cto.com/2001125/724939

但是, 看看吧, 我在window下用 mysq gui 连接linux的mysql服务器, 出现了这样的结果

终于解决了