当我们在Ubuntu下安装完MySQL后，一般都需要设置数据库的默认字符集。
#先看看mysql中的默认字符集。
#登入mysql
mysql -h localhost -u root -p
#查看 character 相关的属性
SHOW VARIABLES LIKE '%character%';
#会得到如下的结果：
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
#打开/etc/mysql/my.cnf
sudo gedit /etc/mysql/my.cnf
#在[client]内，添加 default-character-set 属性www.linuxidc.com
[client]
...
...
default-character-set=utf8
#在[mysqld]内，添加default-character-set=utf8, character-set-server=utf8, default-collation=utf8_unicode_ci
[mysqld]
...
...
default-character-set=utf8
character-set-server=utf8
default-collation=utf8_unicode_ci
#重启 mysql
sudo service mysql restart
#再登进 mysql 看一下字符属性，得如下结果，ok,搞定了
+--------------------------+----------------------------+
| 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 | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
345
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
