mysql 修改字符集為utf8mb4

呂建奎發表於2015-06-14
MySql

ALTER DATABASE profiles CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
ALTER TABLE users CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE users MODIFY column display_name varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci not null comment '暱稱';

show full columns from users;

show create table users;

相關文章