How to insert a picture into database?

[lgreyes]

Hi everybody,

Could somebody tell me how can I insert a picture into a database or maibe where can I get information about this.

Tanks.

 

[mynwo]

Hi,

You will have to store them in blob datatype. Here's an eg.

create table myblob
(
no smallint,
blob_data blob
)

insert into myblob(no, blob_data) values
(1, filetoblob('c:\abc.jpg','client')) ;