MySQL Forums
Forum List  »  General

Re: MySQL 8.0 LOAD DATA INFILE error 1265 Truncated column
Posted by: Anton Bracjun
Date: November 19, 2019 06:03AM

Hi Peter,
thank you for your info. I've fixed secure-file issue, I left it empty for now in order not to be limited in which folder loaded file is.

On dates and time: as you can see those are varchars, not actual date columns.
On capital names: It's windows and will stay so.

Here is the file detail with line which keeps failling:

0 PGEN_TEST.19TXT_000 0 0 20191119 0 0 1 0 10:55:39 0 0 000 1

Here is the same line, but each TAB char is replaced by * and CRLF is marked

Let me know if you have any ideas, please.
THank you.

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.