> What do you need? A CSV file and a table structure? And how do I send attachments?
What's needed to reproduce the problem you reported: Create Table cmd, csv file, Load Data cmd.
> Colorno is a STRING or 5 characters width which contains numerals ('2', '22', '345', etc. )
?! Defined in the table as an int, whence your error "ERROR 1366 (HY000) Incorrect integer value: '\FEFF1' for column 'Colorno' at row 1".
Quote
Loading a string function to varchar(24) example. With 5.7 if the string value was, say, 30 characters. Loading into varchar(24) field it would just chop enough characters from the end to make it fit varchar(24). Now it errors. Is there any setting that can make it like 5.7?
Sql_mode and whether the Load Data uses LOCAL both affect error/warning behaviour, see
https://dev.mysql.com/doc/refman/8.0/en/load-data.html. I'm unaware of 5.7-8.0 differences.