MySQL 8.0 LOAD DATA INFILE error 1265 Truncated column
Hello,
I have a problem and research did not help.
I've migrated database successfully from version 5.7 to 8.0. Most of the tools using database are able to use it, except one, which uploads file into a table and it fails with truncated column 'JID' on row 1.
Now, the file is TAB delimited using windows EoL, 0A0D.
Application triggers upload using statement like this:
LOAD DATA INFILE '[file path]' INTO TABLE [TableName] LINES TERMINATED BY '\r\n';
Same file, logic which creates file and structure works on previous server and MySQL version. Unfortunally we are not able to change application logic or format of data.
Error points to 1st row and 3rd column. That column is type int(10). Order of data and columns in table are correct. Value for 3rd column in file on 1st row is simply 0.
Any ideas?
Thank you very much for help.
Subject
Written By
Posted
MySQL 8.0 LOAD DATA INFILE error 1265 Truncated column
November 15, 2019 04:56AM
November 15, 2019 08:58AM
November 18, 2019 05:06AM
November 18, 2019 05:11AM
November 18, 2019 11:00AM
November 19, 2019 06:03AM
November 19, 2019 12:41PM
November 20, 2019 04:31AM
November 20, 2019 12:02PM
November 21, 2019 05:43AM
November 21, 2019 10:35AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.