Mysql UTF8 - hebrew chars - URGENT!!

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
yhersh
Posts: 22
Joined: Fri 30 Apr 2010 12:13

Mysql UTF8 - hebrew chars - URGENT!!

Post by yhersh » Tue 19 Oct 2010 11:12

Hi,

I get the following error in my mysql instance (windows and UTF8 collation)

mysql server version: 5.1.48-community

devart mysqlConnector version: 5.80.152

Incorrect string value: '\xE5\xE9\xF7\xE5 \xE1...' for column 'additional_details_param_x' at row 1'

I am trying to insert Hebrew chars 'אבג'....

Please advise

Thanks

yhersh
Posts: 22
Joined: Fri 30 Apr 2010 12:13

found the solution....IMPORTANT

Post by yhersh » Tue 19 Oct 2010 13:04

Hi,

I just added CharSet=utf8 to the connection string....and it solved my issue!

Post Reply