Data truncation: Cannot create a JSON value from a string with CHARACTER SET 'binary'.

### 当前使用版本(必填,否则不予处理)
3.5.2
### 该问题是如何引起的？(确定最新版也有问题再提!!!)
autoMapResult已开启,typehandler也已指定
![输入图片说明](https://images.gitee.com/uploads/images/2022/0622/105227_9efd4b05_1528397.png "屏幕截图.png")
![输入图片说明](https://images.gitee.com/uploads/images/2022/0622/105217_62ae9137_1528397.png "屏幕截图.png")
```java
 boolean success = userAddressService.lambdaUpdate()
                .eq(UserAddress::getUserId, ISecurity.user().must().getId())
                .eq(UserAddress::getId, addressId)
                .set(UserAddress::getName, userAddress.getName())
                .set(UserAddress::getMobile, userAddress.getMobile())
                .set(UserAddress::getAreaCode, userAddress.getAreaCode())
                .set(UserAddress::getAddress, userAddress.getAddress())
                .update();
```
 :point_right: 注意第六行 getAreaCode  javatype-> List  jdbctype -> json 
 :point_right: 设置JSON 字段,需要先转成String才,可以如下代码

```java 
   boolean success = userAddressService.lambdaUpdate()
                .eq(UserAddress::getUserId, ISecurity.user().must().getId())
                .eq(UserAddress::getId, addressId)
                .set(UserAddress::getName, userAddress.getName())
                .set(UserAddress::getMobile, userAddress.getMobile())
                .set(UserAddress::getAreaCode, Jackson.writeValueAsString(userAddress.getAreaCode()))
                .set(UserAddress::getAddress, userAddress.getAddress())
                .update();
```

### 重现步骤(如果有就写完整)
1. 数据库字段设置JSON字段
2. 使用lambdaUpdate设置该字段
3. 执行

### 报错信息

Data truncation: Cannot create a JSON value from a string with CHARACTER SET 'binary'.; nested exception is com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Cannot create a JSON value from a string with CHARACTER SET 'binary'.
	at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:88)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)

GVP baomidou/mybatis-plus

内容风险标识

评论 (1)

GVPbaomidou/mybatis-plus

内容风险标识