How can I open them which have already stored in SQLite ??
A:
You can't store files in a SQLite Database. You can store links to files in a SQLite database or you can store binary data.
I recommend reading how SQLite works.
Con
2010-07-05 18:09:25
But I had a sqlite and there are really PDF and XML file in it by checking by sqlite viewer. The datatype is blob.
Kooper
2010-07-05 19:38:53
A:
First of all, I think that it is better to store files as files rather than blob fields in SQLite, and to keep their filenames in DB.
But if you want to proceed with blob fields, you should write byte[] from that blob field to a temporary file with FileOutputStream. After that just open that file.
Rabas
2010-07-05 20:43:27