Store png/pdf file in sqlite

Question

Hello,

How to store pdf,png file in sqlite.

is this possible to store pdf and png file?

Please help me out.

if you have any idea please share with me.

Thanks you,

Answer 1

There is a BLOB data type so I guess you can:

http://www.sqlite.org/datatype3.html

Answer 2

You can store a PDF or PNG file in a BLOB field.

first create the table

create table Blubber ( PK int primary key , BITSINK blob );

then use insert to add the data.

insert into Blubber (PK,BITSINK) 
values (1, 'your blob goes here, best to use bind variables though!');

Tell us what language you are using for advice how to use bind variable.

EDIT just saw this is taged iPhone, the language would be the appropriate C dialect (objective c??)

Answer 3

Hello,

Thanks for quick replay my problem is solved.

I am very thankful you.