How to store and retrieve array of bytes MYSQL

[Gert]

Hi,

I need to store a array() of byte to a mysql field. I created a field in
mysql of type varbinary. But storing and retrieving gives problems.

Please help.

The
strTemp = EnDeCrypt(txt, psw)

Label1.Text = strTemp

encData = System.Text.Enc oding.UTF8.GetB ytes(strTemp)

Dim myconnstring As String = "host=vmge1 ; "

Dim conn As New MySql.Data.MySq lClient.MySqlCo nnection

Dim cmd As New MySql.Data.MySq lClient.MySqlCo mmand

Dim myDataReader As MySql.data.mysq lclient.MySqlDa taReader

Dim oParameter As New MySql.Data.MySq lClient.MySqlPa rameter

conn.Connection String = myconnstring

Dim strQuery As String = "UPDATE klanten SET secret=?ArrayPa rameter"

Try

conn.Open()

cmd.Connection = conn

cmd.CommandType = CommandType.Tex t

cmd.CommandText = strQuery

oParameter.Para meterName = "?ArrayParamete r"

oParameter.DbTy pe = DbType.Binary

oParameter.Valu e = strTemp

Label1.Text = strTemp

cmd.Parameters. Add(oParameter)

cmd.ExecuteNonQ uery()

Catch ex As MySql.Data.MySq lClient.MySqlEx ception

Label1.Text = "Error " & ex.Number & " " & ex.Message

End Try

Dim strQuery2 As String = "SELECT secret from klanten"

cmd.CommandText = strQuery2

myDataReader = cmd.ExecuteRead er()

If myDataReader.Re ad Then

Dim T As String = myDataReader.Ge tString(0)

Label2.Text = T

End If

If Label1.Text = Label2.Text Then Label3.Text = "GELIJK" Else Label3.Text =
"ONGELIJK"