springboot中emoji表情配置及springboot数据源配置区别

springboot mysql 中默认不支持插入emoji表情,
首先确定mysql数据库本身是否支持emoji :mysql配置emoji

然后:DataSource中增加初始化sql配置: set names utf8mb4
首先确定自己使用的springboot整合的数据源是哪种( 有springboot自带的tomcat-jdbc数据源, 也可以使用druid数据源)

1.tomcat-jdbc数据源:

参考源码:tomcat-jdbc_DataSource设置
application.properties中增加:
spring.datasource.initSQL=set names utf8mb4
例如:

#连接池配置(tomcat-jdbc数据源) spring.datasource.initSQL=set names utf8mb4 spring.datasource.max-idle=10 spring.datasource.max-wait=10000 spring.datasource.min-idle=5 spring.datasource.initial-size=5 spring.datasource.validation-query=SELECT 1 spring.datasource.test-on-borrow=false spring.datasource.test-while-idle=true spring.datasource.time-between-eviction-runs-millis=18800

2. druid数据源

application.properties中增加:
spring.datasource.connectionInitSqls=set names utf8mb4
例如:

####  连接池配置(pom引入:druid ,新增@Configuration: com.*.*.*.DruidConfig)   ####### spring.datasource.type=com.alibaba.druid.pool.DruidDataSource spring.datasource.max-idle=10 spring.datasource.max-wait=10000 spring.datasource.min-idle=5 spring.datasource.initial-size=5 spring.datasource.validation-query=SELECT 1 spring.datasource.test-on-borrow=false spring.datasource.test-on-return=false spring.datasource.test-while-idle=true spring.datasource.pool-prepared-statements=true spring.datasource.maxActive=20 spring.datasource.maxPoolPreparedStatementPerConnectionSize=20 spring.datasource.filters=stat,wall,log4j spring.datasource.connectionProperties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000 spring.datasource.timeBetweenEvictionRunsMillis=60000 spring.datasource.minEvictableIdleTimeMillis=300000 spring.datasource.connectionInitSqls=set names utf8mb4