From: Gary Wong
Date: September 23 2004 6:47am
Subject: Does "Mysql Connector/Net provider" support unicode chinese charactor?
List-Archive: http://lists.mysql.com/dotnet/5
Message-Id: <004301c4a139$308ea8c0$850aa8c0@ETECHSHK.COM>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_003F_01C4A17C.3E2E87F0"

------=_NextPart_000_003F_01C4A17C.3E2E87F0
Content-Type: text/plain;
	charset="big5"
Content-Transfer-Encoding: 7bit

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()

------=_NextPart_000_003F_01C4A17C.3E2E87F0--