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

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

Postby trieu van » Tue 04 Jan 2005 10:52

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!
trieu van
 

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

Postby Oleg » Wed 05 Jan 2005 14:51

But you use the old version of MySQLDirect .NET. Please download MySQLDirect .NET version 2.70, it solves the problem.
Oleg
Devart Team
 
Posts: 264
Joined: Thu 28 Oct 2004 13:56


Return to dotConnect for MySQL