springboot+mysql支持emoji表情utf8mb4

1.修改表字符集
ALTER table usr_user charset=utf8mb4;
2.修改字段字符集
ALTER table usr_user modify nick_name varchar(100) character set utf8mb4 collate utf8mb4_general_ci comment ‘姓名’;

3.代码中连接池增加

@Bean(destroyMethod="close",initMethod="init")
@ConfigurationProperties(prefix="spring.datasource")
publicDataSourcedataSource(){
	DruidDataSourcedataSource=newDruidDataSource();
	dataSource.setPasswordCallback(dbPasswordCallback());
	//支持表情
	StringTokenizertokenizer=newStringTokenizer("SET NAMES utf8mb4",";");
	dataSource.setConnectionInitSqls(Collections.list(tokenizer));//重点设置该参数
	return  dataSource;
}

//支持表情
StringTokenizertokenizer=newStringTokenizer(“SETNAMESutf8mb4”,";");
dataSource.setConnectionInitSqls(Collections.list(tokenizer));//重点设置该参数