在ubuntu15.04安装了下mysql,然后想设置编码为utf8,搜索了一下网上的教程,大致是以下这样子:
mysql默认编码为latin1,使用mysql -u root -p命令进入mysql控制台
输入mysql>show variables like ‘character%’; 命令显示mysql数据库的编码.
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_