MySQL Forums
Forum List  »  General

Re: MySQL 8.0 LOAD DATA INFILE error 1265 Truncated column
Posted by: Anton Bracjun
Date: November 20, 2019 04:31AM

Hi Peter,
error I got on v8.0 is "Truncated value for column JID on row 1". Same file, same create table on v5.7 (except it's MyISAM nod INNODB) does not produce any error and loads data.

I've compared data to list and order of columns, all looks good. One more behaviour I've seen is that if I used file where there were no "_" chars, they were loaded ok.

Any idea why could that be?

Options: ReplyQuote

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.