I want to store image files into monetdb sql server. I think there are two approaches to do it:

the first one is to store the file's full path in a column with varchar type, the second one is to store the image data in a column with blob type. I don't want to see a lot of small image files in the directory, so I choose the second approach.

 

After reading the monetdb manual, I find some examples like this:

 

sql> insert into t1 values (1, blob '012');

 

I think this is not enough. I also try to use odbc api to store binary data into monetdb, but failed.

 

So please help me to write the blob data into monetdb, as well as the read operation. Maybe there are other ways I don't know, please tell me, thanks!