Page 1 of 1

Problem with Polish chars (Devart.Data.MySql )

Posted: Mon 19 Jan 2009 11:23
by WildEye
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ł

Posted: Mon 19 Jan 2009 16:53
by Shalex
We have answered you by e-mail.

Incorrect string value

Posted: Tue 25 Aug 2009 16:32
by mHook
I also have same error.
And string returned from MySQL is not returned correctly (utf-8 ) and using LinqToSql

Re: Incorrect string value

Posted: Tue 25 Aug 2009 17:27
by mHook
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