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ł
Problem with Polish chars (Devart.Data.MySql )
Incorrect string value
I also have same error.
And string returned from MySQL is not returned correctly (utf-8 ) and using LinqToSql
And string returned from MySQL is not returned correctly (utf-8 ) and using LinqToSql
Re: Incorrect string value
Solved by changing connection string to include Unicode=truemHook wrote:I also have same error.
And string returned from MySQL is not returned correctly (utf-8 ) and using LinqToSql