Problem with Unicode in MySQLDirect 2.4, MySQL 4.1 and .NET 2003...
Posted: 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!
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!