mysql编码问题一直是一个比较棘手的问题。下面就一步一步讲述一下设置方法。
查看编码使用
SHOW VARIABLES LIKE ‘character_set_%’;
1.在/etc/my.cnf中追加
[mysql]
default-character-set =utf8
然后查看编码结果为:
2.修改服务器编码;
set character_set_server = utf8;
查看编码:
3.修改创建的数据库的默认编码
set character_set_database = utf8;
查看编码:
一个简短的sql测试一下:
mysql> create database test_encode;
Query OK, 1 row affected (0.00 sec)
mysql> use test_encode;
Database changed
mysql> create table person(name varchar(64)) default charset=utf8;
Query OK, 0 rows affected (0.02 sec)
mysql> insert person values("谷传杭");
Query OK, 1 row affected (0.00 sec)
mysql> select * from person;
+-----------+
| name |
+-----------+
| 谷传杭 |
+-----------+
1 row in set (0.00 sec)
mysql>
关于centos7下,mysql安装请参考:
http://blog.csdn.net/guchuanhang/article/details/78612100