mysql解决中文乱码问题

下载了一个项目源码，在自己电脑eclipse中导入了，并且跑起来了，测试下功能发现插入中文数据会显示乱码问题。

使用eclipse的debug模式调试发现页面传递的数据确实是中文，但是插入到数据库变成了乱码。解决方法如下：

mysql> use db_jxc;
Database changed
mysql> show create database db_jxc
    -> ;
+----------+-----------------------------------------------------------------+
| Database | Create Database                                                 |
+----------+-----------------------------------------------------------------+
| db_jxc   | CREATE DATABASE `db_jxc` /*!40100 DEFAULT CHARACTER SET utf8 */ |
+----------+-----------------------------------------------------------------+
1 row in set (0.00 sec)

我的数据库db_jxc确实是utf8编码。
查询表的编码

mysql> show create table t_customer;
+------------+---------------------------------------------------------
------------------------------------------------+
| Table      | Create Table
                                                |
+------------+---------------------------------------------------------
------------------------------------------------+
| t_customer | CREATE TABLE `t_customer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `address` varchar(300) DEFAULT NULL,
  `contact` varchar(50) DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  `number` varchar(50) DEFAULT NULL,
  `remarks` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 |
+------------+---------------------------------------------------------
------------------------------------------------+
1 row in set (0.00 sec)

发现也是utf8编码
查询下刚插入的数据，发现存到数据库里是乱码，如下：

mysql> select * from t_customer;
+----+---------------------+---------+------------------+---------------+-----------+
| id | address             | contact | name             | number        | remarks   |
+----+---------------------+---------+------------------+---------------+-----------+
|  1 | 福州新弯曲5号       | 小李子  | 福州艾玛超市     | 2132-23213421 |           |
|  2 | 天津兴达大街888号   | 小张    | 天津王大连锁酒店 | 23432222311   | 优质客户  |
|  3 | 大凉山妥洛村        | 小爱    | 大凉山希望小学   | 233243211     | 照顾客户2 |
|  4 | 南通通州新金路888号 | 王二小  | 南通通州综艺集团 | 1832132321    |           |
|  7 | ????                | ???     | 503??            | 18679758769   |           |
+----+---------------------+---------+------------------+---------------+-----------+
5 rows in set (0.03 sec)

查询下数据库的编码：

mysql> show variables like 'char%';
+--------------------------+---------------------------------------------------------+
| Variable_name            | Value                                                   |
+--------------------------+---------------------------------------------------------+
| character_set_client     | gbk                                                     |
| character_set_connection | gbk                                                     |
| character_set_database   | utf8                                                    |
| character_set_filesystem | binary                                                  |
| character_set_results    | gbk                                                     |
| character_set_server     | latin1                                                  |
| character_set_system     | utf8                                                    |
| character_sets_dir       | C:\Program Files\MySQL\MySQL Server 5.6\share\charsets\ |
+--------------------------+---------------------------------------------------------+
8 rows in set (0.00 sec)

发现不统一了，修改成utf8

set character_set_client = utf8;
set character_set_connection = utf8;
set character_set_database = utf8;
set character_set_results = utf8;
set character_set_server = utf8;

设置之后，再次查询如下：

mysql> show variables like 'char%';
+--------------------------+---------------------------------------------------------+
| Variable_name            | Value                                                   |
+--------------------------+---------------------------------------------------------+
| character_set_client     | utf8                                                    |
| character_set_connection | utf8                                                    |
| character_set_database   | utf8                                                    |
| character_set_filesystem | binary                                                  |
| character_set_results    | utf8                                                    |
| character_set_server     | utf8                                                    |
| character_set_system     | utf8                                                    |
| character_sets_dir       | C:\Program Files\MySQL\MySQL Server 5.6\share\charsets\ |
+--------------------------+---------------------------------------------------------+
8 rows in set (0.00 sec)

在控制台插入数据中文正常了，但是这种解决方式只是临时的，要永久生效还得修改配置文件。
改动mysql配置文件/etc/my.cnf。

[mysqld]
character-set-server=utf8 
[client]
default-character-set=utf8 
[mysql]
default-character-set=utf8

查看mysql的安装目录和数据存放目录

mysql> select @@basedir;
+------------------------------------------+
| @@basedir                                |
+------------------------------------------+
| C:\Program Files\MySQL\MySQL Server 5.6\ |
+------------------------------------------+
1 row in set (0.00 sec)

mysql> select @@datadir;
+-----------------------------------------------+
| @@datadir                                     |
+-----------------------------------------------+
| C:\Program Files\MySQL\MySQL Server 5.6\data\ |
+-----------------------------------------------+
1 row in set (0.00 sec)

拷贝my-default.ini，并修改成my.ini
重启mysql服务。