Problem with Polish chars (Devart.Data.MySql )

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
WildEye
Posts: 1
Joined: Mon 19 Jan 2009 10:31

Problem with Polish chars (Devart.Data.MySql )

Post by WildEye » Mon 19 Jan 2009 11:23

I have a problem with polish charset in my program.
I use VS 2005 + C#(Framework 2.0) + Devart.Data.MySql +MySql 5.1.11 + Windows XP SP2

When I try to insert row with value "ąść" into db using SP i recive error:
"Incorrect string value: '\xC5\x9B\xC4\x85\xC4\x87' for column 'login' at row 1"

Column "login" is in Utf8

In c# i have :
command.Connection.Unicode = true;


Any idea what is wrong ?

Paweł

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Mon 19 Jan 2009 16:53

We have answered you by e-mail.

mHook
Posts: 6
Joined: Tue 18 Aug 2009 13:01

Incorrect string value

Post by mHook » Tue 25 Aug 2009 16:32

I also have same error.
And string returned from MySQL is not returned correctly (utf-8 ) and using LinqToSql

mHook
Posts: 6
Joined: Tue 18 Aug 2009 13:01

Re: Incorrect string value

Post by mHook » Tue 25 Aug 2009 17:27

mHook wrote:I also have same error.
And string returned from MySQL is not returned correctly (utf-8 ) and using LinqToSql
Solved by changing connection string to include Unicode=true

Post Reply