Mysql支持utf8mb4编码
[i=s] 本帖最后由 Miker 于 2016-12-15 15:40 编辑 [/i]修改数据库和表的属性为utf8mb4[code]ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;[/code]linux下修改mysql的配置文件
# vi /ect/my.cnf
增加[code][client]
default-character-set = utf8mb4
[mysql]
default-character-set = utf8mb4
[mysqld]
character-set-client-handshake = true
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'[/code]
页:
[1]