解决mysql的longtext报错java.sql.SQLException: Incorrect string value

问题

项目打包成jar，然后运行项目，在想数据库longtext字段增加数据会报错
解决办法，在数据库连接时增加 &clobCharacterEncoding=utf-8

完整代码

spring.datasource.username                                  = root
spring.datasource.password                                  = ENC(DBa4AxW9hmbHigeZq7XjZw==)
spring.datasource.url                                       = jdbc:mysql://127.0.0.1:3306/xxx?useUnicode=true&characterEncoding=utf-8&clobCharacterEncoding=utf-8&serverTimezone=Asia/Shanghai&zeroDateTimeBehavior=CONVERT_TO_NULL&allowPublicKeyRetrieval=true&useSSL=false&rewriteBatchedStatements=true
spring.datasource.driver-class-name                         = com.mysql.cj.jdbc.Driver
spring.datasource.type                                      = com.zaxxer.hikari.HikariDataSource