Problem with Polish chars (Devart.Data.MySql )

Problem with Polish chars (Devart.Data.MySql )

Postby 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ł
WildEye
 
Posts: 1
Joined: Mon 19 Jan 2009 10:31

Postby Shalex » Mon 19 Jan 2009 16:53

We have answered you by e-mail.
Shalex
Devart Team
 
Posts: 7305
Joined: Thu 14 Aug 2008 12:44

Incorrect string value

Postby 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

Postby 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
mHook
 
Posts: 6
Joined: Tue 18 Aug 2009 13:01


Return to dotConnect for MySQL