MySQL Forums
Forum List  »  Connector/ODBC

Please explain why i get a incorrect string value error
Posted by: Doug Barger
Date: May 05, 2020 11:10AM

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.

Options: ReplyQuote


Subject
Written By
Posted
Please explain why i get a incorrect string value error
May 05, 2020 11:10AM


Sorry, only registered users may post in this forum.

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.