Mysql之修改表的编码字符集 博客分类: DB
程序员文章站
2024-02-25 23:53:03
...
--改变表的编码,为utf8mb4
alter table `someabcd_cms` convert to character set utf8mb4;
除此之外还需要注意配置文件相关的支持
[client]
default-character-set = utf8mb4
[mysql]
default-character-set = utf8mb4
[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'