blob « sqlite « Java Database Q&A

1. sqlite setBytes() not working for BLOB data type on Windows

I am using sqlite (version 3.7.5) with sqlite jdbc driver provided at I asked an almost identical question few months back at xerial forums (, but never got any ...

2. cannot save image as blob to sqlite

I am using SQLite and I cannot save a image to the database. This is my code :

File file = new File(url);
  try {
    fis = new ...

3. sql search for a number into a BLOB (list of numbers)

I've stored an ArrayList of longs (ID's) into a Blob column. (followed question: BLOB vs. VARCHAR for storing arrays in a MySQL table) That works, but now I've a problem: how can ...