Problem with Unicode in MySQLDirect 2.4, MySQL 4.1 and .NET 2003...

[trieu van]

Hi,

This is a problem I see... I tried as following:
+ First of all, install database server MySQL with default character set utf8.
+ Second, create table with utf8 support.
create table EMPLOYEE default character set utf8 collate utf8_unicode_ci
(
cEmpTest varchar(50) character set utf8 collate utf8_unicode_ci
)

+ Third, code in VS.NET:
string strConn="server=xxx;database=xxx;user id=xxx;password=xxx;unicode=true";
...

+ Fourth, try... AND SEE RUNNING WRONG IN RESULT IF USING UNICODE IN THE TABLE!

Pls Show Me...what is wrong! Many Thanks!

[Oleg]

But you use the old version of MySQLDirect .NET. Please download MySQLDirect .NET version 2.70, it solves the problem.