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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
tsmgeekCommented:
set connection to latin1, do type conversion within .NET of your text to latin 1 before sending it to mysql
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.