字符集编码
utf8mb4
1、数据库配置
[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'
[client]
default-character-set=utf8mb4
2、创建数据库
CREATE DATABASE test CHARSET=utf8mb4;
3、创建表
CREATE TABLE `talk` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`content` varchar(255) CHARACTER SET utf8mb4 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
字段
注意字段的设置
`content` varchar(255) CHARACTER SET utf8mb4 NOT NULL