store chinese again

[YAN]

i cannot store unicode in thie way, please help!

Dim souce As Byte() = System.Text.Encoding.Unicode.GetBytes("CHINESE")
Dim sSql As String = "insert into tblpitems (fldItmDesc1) values (@a)"
g_dbCommand.CommandText = sSql
Dim paramData As MySqlParameter = New MySqlParameter("@a",
ByteFX.Data.MySqlClient.MySqlDbType.VarChar)
paramData.Value = souce
g_dbCommand.Parameters.Add(paramData)
DBConnection.ExecuteNonQuery()

i store the string as "System.Byte[]", what can i do?

[Jon Skeet [C# MVP]]

YAN <YA*@discussions.microsoft.com> wrote:

i cannot store unicode in thie way, please help!

Dim souce As Byte() = System.Text.Encoding.Unicode.GetBytes("CHINESE")
Dim sSql As String = "insert into tblpitems (fldItmDesc1) values (@a)"
g_dbCommand.CommandText = sSql
Dim paramData As MySqlParameter = New MySqlParameter("@a",
ByteFX.Data.MySqlClient.MySqlDbType.VarChar)
paramData.Value = souce
g_dbCommand.Parameters.Add(paramData)
DBConnection.ExecuteNonQuery()

i store the string as "System.Byte[]", what can i do?

You've specified that it's a VarChar, which means you should specify a
string, not a byte array.

You really shouldn't *need* to do any encoding/decoding yourself at
all. Are you sure your MySql database has been set up to use Unicode?
(I don't know whether it does by default or not.)

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too