Mysql UTF8 - hebrew chars - URGENT!!

Mysql UTF8 - hebrew chars - URGENT!!

Postby 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

Postby yhersh » Tue 19 Oct 2010 13:04

Hi,

I just added CharSet=utf8 to the connection string....and it solved my issue!
yhersh
 
Posts: 22
Joined: Fri 30 Apr 2010 12:13


Return to dotConnect for MySQL