方法1;

进入cmd中 进入>mysql

mysql> show variables like 'character%';
+--------------------------+--------------------------+
| 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       | D:\mysql\share\charsets\ |
+--------------------------+--------------------------+
8 rows in set, 1 warning (0.00 sec)

mysql> set character_set_database = utf8 ;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> set character_set_result = utf8 ;
ERROR 1193 (HY000): Unknown system variable 'character_set
mysql> set character_set_results= utf8;
Query OK, 0 rows affected (0.00 sec)

mysql> set character_set_server=utf8;
Query OK, 0 rows affected (0.00 sec)

mysql> show variables like 'character%';
+--------------------------+--------------------------+


方法2: 在myeclipse 中的 DB browes 中修改路径

                jdbc:mysql://localhost:3306/db_online?useUnicode=true&characterEncoding=utf8在后面加入编码字符集


方法三: 在mysql 的my.ini中进行配置默认编码字符集