uncategorized SQLException for SQL []; SQL state [HY000]; error code [1366]; Incorrect string value:

最新推荐文章于 2024-08-19 09:02:11 发布

lee_126

最新推荐文章于 2024-08-19 09:02:11 发布

阅读量9.4k

点赞数

CC 4.0 BY-SA版权

分类专栏：异常

本文链接：https://blog.csdn.net/lily_better/article/details/100937668

预发环境中遇到一个SQLException，涉及SQL操作的字符串值不匹配。原来表send_order_main的special_address字段使用的是latin1字符集和latin1_swedish_ci排序规则。为解决此问题，已将字符集和排序规则更改为utf8mb4和utf8mb4_bin，更改后问题得到正确解决。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

预发环境出现一个问题，

2019-09-17 18:39:00.760 [mro: a2ec1605f7f56edd][http-nio-8002-exec-2] ERROR com.runlion.sat.tools.handler.ExceptionHandler - >>>>>>>>> 全局异常 Incorrect string value: '\xE9\x98\xBF\xE9\x81\x93...' for column 'special_line' at row 1 >>>>>>>>>>>>>>
org.springframework.jdbc.UncategorizedSQLException: 
### Error updating database.  Cause: java.sql.SQLException: Incorrect string value: '\xE9\x98\xBF\xE9\x81\x93...' for column 'special_line' at row 1
### The error may involve com.runlion.sat.wms.mapper.SendOrderMainMapper.insertSelective-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO send_order_main  ( id,owner_id,order_no,oms_no,oms_order_id,customer_no,send_time,order_date,receiver_party,receiver,receiver_phone,receiver_adress_province_id,receiver_adress_city_id,receiver_adress_area_id,receiver_adress,source,delivery_type,business_type,carrier_id,carrier