MAC OS中 mysql数据库编码设置
数据库编码查看方法:
mysql> show variables like '%char%';
将数据编码设置为utf8
1.停止mysql
2.修改my.cnf
cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf
vim /etc/my.cnf
add below code:
[client]
default-character-set=utf8
[mysqld]
character-set-server=utf8
default-storage-engine=INNODB
collation-server=utf8_general_ci
3.重启mysql
数据库表的编码设置
Use the ALTER DATABASE and ALTER TABLE commands.
ALTER DATABASE databasename CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;