Cause: java.sql.SQLException: Data truncated for column**

SQLException: Data truncated for column**"/>

Cause: java.sql.SQLException: Data truncated for column**

报错信息：

message: "org.springframework.dao.DataIntegrityViolationException: ↵### Error updating database. Cause: java.sql.SQLException: Data truncated for column 'package_name' at row 1↵### The error may exist in class path resource [mapper/fin/AccountInformationMapper.xml]↵### The error may involve defaultParameterMap↵### The error occurred while setting parameters↵### SQL: insert into fin_account_information_package(sim,package_code,package_name,account_amount,operators,first_month,now_month,is_receivable) select sim,package_code,package_name,sum(item_account_amount),operators,first_month,now_month, is_receivable from fin_account_information_item group by sim,package_code,now_month,is_receivable↵### Cause: java.sql.SQLException: Data truncated for column 'package_name' at row 1↵; Data truncated for column 'package_name' at row 1; nested exception is java.sql.SQLException: Data truncated for column 'package_name' at row 1"

错误分析：

该错误报的是数据库'package_name'字段被截断，分析错误原因：

数据库里两个表的同一字段长度不一致，例如a表中该字段长度设置为64，b表设置为32，a表中存放了一个字段长度为33的数据，某一操作是把a表的该字段值存放到b表，这时就会导致在表给表赋值的时候出现a表的该字段长度过长而被截断(truncated)。

建议：

在建表时尽量统一业务中存放不同表的相同字段的设置，包括名称、类型和长度等。