Re: MySQL 8.0 LOAD DATA INFILE error 1265 Truncated column

[Anton Bracjun]

CREATE TABLE `palajjobs` (
`SEQ` int(10) unsigned NOT NULL DEFAULT '0',
`JOB_ID` varchar(25) NOT NULL,
`JID` int(10) unsigned NOT NULL DEFAULT '0',
`COUNT` varchar(5) NOT NULL,
`DATE_IN` varchar(8) NOT NULL,
`DATE_PROD` varchar(8) NOT NULL,
`STATUS` int(10) unsigned NOT NULL,
`GENERATION` char(1) NOT NULL,
`START_REC` int(10) unsigned NOT NULL,
`END_REC` int(10) unsigned NOT NULL,
`NOTE` varchar(255) NOT NULL,
`DATE_DISPATCH` varchar(8) NOT NULL,
`TIME_IN` varchar(8) NOT NULL,
`TIME_PROD` varchar(8) NOT NULL,
`TIME_DISPATCH` varchar(8) NOT NULL,
`SCRAPS` int(10) unsigned NOT NULL,
`FSTATUS` int(10) unsigned NOT NULL DEFAULT '0',
`TMPL_ID` varchar(3) NOT NULL DEFAULT '0',
`INST_ID` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`SEQ`),
KEY `STATUS` (`STATUS`),
KEY `DATE_IN` (`DATE_IN`),
KEY `DATE_PERSO` (`DATE_PROD`),
KEY `JOB_ID` (`JOB_ID`),
KEY `JID` (`JID`),
KEY `FSTATUS` (`FSTATUS`),
KEY `PLAST_ID` (`TMPL_ID`),
KEY `INST_ID` (`INST_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=cp852;