问题
项目打包成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