Blobs

Hello every one;

 

I am trying to find out how to save / fetch BLOBs. (I use MySQL)

 

I have a table of companies and I want to save each company's logo as a BLOB
 The intention is to set up a seperate table which holds only the blobs, and
set up a one-to-one relationship Company <-> Logos. (Don't want BLOB fetched
when fetching each company to avoid overhead - only want to fetch BLOB when
required).



Can some one tell me how to do this please. Some sample code would be great.

 

Thank you. 

 

Cheers,

Bill.