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.
Gary Wong wrote:
>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
>Any comment? Please help! Thanks
> Dim myConnectionString As String = ""
> Dim sQuery As String = ""
> myConnectionString = "Database=test;Data Source=localhost;User
> Dim myConnection As New MySqlConnection(myConnectionString)
> Dim myInsertQuery As String = "INSERT INTO activitydef (ShortName,
>Type, Filter, Description, CreatedBy, CreatedDateTime, LastUpdatedBy,
> 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
Reggie Burnett, Software Developer
MySQL Inc, http://www.mysql.com