From: Reggie Burnett
Date: October 27 2004 3:38pm
Subject: Re: Does "Mysql Connector/Net provider" support unicode chinese charactor?
List-Archive: http://lists.mysql.com/dotnet/57
Message-Id: <417FC109.3000601@mysql.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=Big5
Content-Transfer-Encoding: 7bit

If I did not respond to this, I apologize. Beta 2 (which should have
been out a couple of days ago) have some bugfixes that help better
support Chinese and other languages.

-reggie

Gary Wong wrote:

>Hi,
>
>Does "Mysql Connector/Net provider" support unicode chinese charactor?
>I try with following codes to insert a unicode chinese string in parament
>"?a1", but it does not work, the chinese charactor stored as ???? in mysql
>database.
>
>Any comment? Please help! Thanks
>
>Gary
>=======================================
>
>        Dim myConnectionString As String = ""
>        Dim sQuery As String = ""
>
>       myConnectionString = "Database=test;Data Source=localhost;User
>Id=root;Password=;"
>
>        Dim myConnection As New MySqlConnection(myConnectionString)
>
>        Dim myInsertQuery As String = "INSERT INTO activitydef (ShortName,
>Type, Filter, Description, CreatedBy, CreatedDateTime, LastUpdatedBy,
>LastUpdatedDateTime) "
>        myInsertQuery &= " Values(?a1, 'Type', 'Filter', 'Desc', '', '', '',
>'')"
>
>        Dim myCommand As New MySqlCommand(myInsertQuery)
>
>        Dim op As MySqlParameter = myCommand.Parameters.Add(New
>MySqlParameter("?a1", MySqlDbType.VarChar, 100))
>        op.Direction = ParameterDirection.Input
>        op.Value = sInput
>        myCommand.Connection = myConnection
>        myConnection.Open()
>        myCommand.ExecuteNonQuery()
>        myConnection.Close()
>
>  
>

-- 
Reggie Burnett, Software Developer
MySQL Inc, http://www.mysql.com