Please explain why i get a incorrect string value error
I have a csv text file that has chars 32-127 only, Filtered out all other chars.
i am getting this error during import;
Error Code: 1366. Incorrect string value: '\xEF\xBF\xBDs b...' for column 'pcdbpartsdescriptionPartsDescription' at row 6168
here is the code generating the error;
load data infile 'C:\\ProgramData\\MySQL\\MySQL Server 8.0\\Uploads\\Pass0.csv'
into table autoscratch.pass0
fields terminated by ','
enclosed by '"'
lines terminated by '\r\n'
ignore 1 rows;
I don't understand why this is a problem, it is a simple text file. I have read allot about code-pages, i have read all the posts i can and i cannot find an answer that makes sense.
Subject
Written By
Posted
Please explain why i get a incorrect string value error
May 05, 2020 11:10AM
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.