[Mono-dev] Support for blobs in SQLite

[pablosantosluac at terra.es]

Hello,

As far as I know there is no way to insert blobs using the SQLite provider 
included in mono. I've checked the latests sources and I can't find the code 
handling this kind of paramenter.

I tried to recompile Mono.Data.SqliteClient.dll adding the following to 
SqliteCommand.cs in BindParameters3:

else if (ptype.Equals (typeof( System.Byte[])))

{

  err = Sqlite.sqlite3_bind_blob(pStmt, i, (System.Byte[]) param.Value, 
((byte[])param.Value).Length,   System.IntPtr.Zero);

}



With this change is possible to read and write blobs...

Can somebody add these 4 lines in the next release???



Thanks,



pablo