MySQL ODBC Exception "Incorrect String Value: '\xEF\xBF\xBD' for column 'ExtractText' at row 1

The error above comes up when I try to execute an INSERT query fromk VB.NET using MySQL ODBC connector.

I found some posts about the error above suggesting that it may be related to the character set used by the connection. I tried modifying my connection string using CharSet = latin1 and CharSet = UTF8 parameters. The error still comes up.
Who is Participating?
tsmgeekConnect With a Mentor Commented:
set connection to latin1, do type conversion within .NET of your text to latin 1 before sending it to mysql
post an example of the query you are sending

what charset is the data in .NET and what charset was the table in mysql created as
cyber-33Author Commented:
The table is created using "latin1 - default collation".

I cannot really post the entire query - it is very large. It inserts a 50 page long text into a "mediumtext" size column.

Also, I suspect that the error '\xEF\xBF\xBD' refers to some chacters, that may not be visible. Not sure.

cyber-33Author Commented:
Here is an interesting article on how to do the conversion:

I will try it and award you the points if this works.

Thank you.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.