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