Can not display correctly utf8 data with asp.net

[nt21k]

Dear,

I got a problem with mysql database using asp.net to retrieve data. I stores datas under format text utf8 via phpMyadmin into Mysql server. Then I make a connection to this database using asp.net to retrieve the data. The result is that the data is displayed correctly with phpMyadmin but is not displayed correctly in the web page.

Of course, I have added charset=utf8 at the end of the connection string as suggested in some posts. I also tried to modifiy the column or table with utf8 as following :

ALTER TABLE test CHARACTER SET utf8 COLLATE utf8_general_ci;

It shows me an error of syntax.

SHOW VARIABLES give me that the character set is latin1, but I can not set it again to utf8 with SET CHARACTER SET utf8;

The data stored in Mysql database is in vietnamese and the driver used to connect is MyODBC 3.51.

Thank you for your helps.

Thanh NGUYEN