List:MySQL and .NET« Previous MessageNext Message »
From:Farshid Hosseini Date:October 25 2007 12:47pm
Subject:Problem with Inserting UTF-8 Data
View as plain text  
Hi.

I use Mono 1.2.5 SVN on Ubuntu Feisty, latest stable .NET Connector and 
MySQL server 5 from Ubuntu repositories.

When I insert data into a database table using a stored procedure and 
from an ASP.NET page, everything which needs encoding changes to ? .

Database default character set is utf-8 and all fields are set to use 
utf-8 and table default character set is utf-8. I have also added 
"charset=utf8;" to my connection string. Default character set for my 
    ASP.NET page is already set to utf-8. These are all the solutions I 
found in other websites and none of them worked for me.

By the way, if I insert data directly by executing a command on the 
server (using query browser, for example) everything is okay and all 
characters are retrieved and shown correctly.

Thanks for any help.
Thread
Problem with Inserting UTF-8 DataFarshid Hosseini25 Oct