Android Question Insert zip file in to a database

[apty]

i am looking for a way of inserting a zip file in to mysql table. I am using the following code to get the zip file

Dim InputStream1 As InputStream
    InputStream1 = File.OpenInput(File.DirDefaultExternal,"edit.zip")
    Dim OutputStream1 As OutputStream
    OutputStream1.InitializeToBytesArray(1000)
    File.Copy2(InputStream1, OutputStream1)
     'declares an empty array
     OutputStream1.ToBytesArray
    Buffer = OutputStream1.ToBytesArray

How can i insert the buffer to the table? if i try something like "update tba set zipfile=" Array As Object(Buffer) i get an error that the object is converted to string

 

[Erel]

Correct way to read a file into an array of bytes:

Dim buffer() As Byte = Bit.InputStreamToBytes(File.OpenInput(...))

Adding a blob:

SQL.ExecuteNonQuery2("update tba set zipfile= ?", Array (buffer))

 

[apty]

Thank you very much Erel. What if i want to add a where condition after Array (buffer))? Please help

 

[Erel]

SQL.ExecuteNonQuery2("update tba set zipfile= ? WHERE col1 = 'a' AND col2 = ?", Array (buffer, b))

 

[apty]

Thank you very much