Data truncation: Cannot create a JSON value from a string with CHARACTER SET 'binary'. · Issue #I5DHCW · baomidou/mybatis

您所在的位置：网站首页 › images/2022-04 › Data truncation: Cannot create a JSON value from a string with CHARACTER SET 'binary'. · Issue #I5DHCW · baomidou/mybatis

Data truncation: Cannot create a JSON value from a string with CHARACTER SET 'binary'. · Issue #I5DHCW · baomidou/mybatis

2023-03-30 06:59| 来源: 网络整理| 查看: 265

当前使用版本(必填,否则不予处理)

3.5.2

该问题是如何引起的？(确定最新版也有问题再提!!!)

autoMapResult已开启,typehandler也已指定输入图片说明

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();

注意第六行 getAreaCode javatype-> List jdbctype -> json 设置JSON 字段,需要先转成String才,可以如下代码

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(); 重现步骤(如果有就写完整) 数据库字段设置JSON字段使用lambdaUpdate设置该字段执行报错信息

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)

【本文地址】

Data truncation: Cannot create a JSON value from a string with CHARACTER SET 'binary'. · Issue #I5DHCW · baomidou/mybatis

Data truncation: Cannot create a JSON value from a string with CHARACTER SET 'binary'. · Issue #I5DHCW · baomidou/mybatis

今日新闻

推荐新闻