Questions

According to the error report, the field defined in the database is too short to store new data

Solution

  @Column(length = 3000)
  private String cellExcel;

Manually define the length of the field, but it will not take effect on the existing table, so you still need to use SQL statements to manually modify the length of the table field, that is:

ALTER TABLE mydb.form_template_field MODIFY COLUMN cell_excel VARCHAR(3000);

Similar Posts:

• [Solved] SQL Error (3621): String or binary data would be truncated The statement has been terminated.
• Error in importing excel file from SQL Server
• SQL Error: 1064, SQLState: 42000 [Three Methods to Solve]
• used in key specification without a key length
• Python uses xlwt length limit to report errors
• Solution of data truncated for column ‘xxx’ in MySQL
• [Solved] Oracle :value too large for column “SCHEMA”.”TABLE”.”COLUMN” (actual: 519, maximum: 500)
• Python: How to Batch Read the Form Information in Word and output them to Excel file
• Kingbasees supports column encryption
• MySQL Error Number 1005 Can’t create table (Errno:150)