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.
cyber-33Asked:
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
0
 
tsmgeekCommented:
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
0
 
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.

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

http://msdn.microsoft.com/en-us/library/kdcak6ye.aspx

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

Thank you.
0
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.