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!
Problem with Unicode in MySQLDirect 2.4, MySQL 4.1 and .NET 2003...
Re: Problem with Unicode in MySQLDirect 2.4, MySQL 4.1 and .NET 2003...
But you use the old version of MySQLDirect .NET. Please download MySQLDirect .NET version 2.70, it solves the problem.