Using the Android API, I'd like to do something like SELECT * from
my_table WHERE my_blob=?

My problem is, all of the query methods only take strings as a parameter
for the '?' placeholder. How am I supposed to pass in a byte array?

I already checked for a convert/cast function so I could use WHERE
my_blob=CONVERT_STRING_TO_BLOB(?) but I did not find anything like this.

Yes, my BLOBs are longer than 8 bytes, so I can't use INTEGER.

And I'd like to stick with BLOB because TEXT (with hex encoding) takes
twice the amount of space.

Cheers,

Andreas

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to