Re: MySQL 8.0 LOAD DATA INFILE error 1265 Truncated column

[Anton Bracjun]

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
0*PGEN_TEST.19TXT_000*0*0*20191119**0*0*1*0***10:55:39***0*0*000*1CRLF

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