[thelist] Storing an image in mysql db (using perl)

[Katherine Spice]

Adrian Fischer wrote:
> 
> Hi Gang,
> 
> Is it possible to store an image in a mysql db.  Presently I am uploading
> the images to a directory and just saving the url to the image in the db.  I
> thought it might be more econimical to have the image with the rest of the
> record.

Yep - you store it as a blob (Binary Large Object). This here url is a
good place to start (with example code and everthing!)
http://www.ucc.gu.uwa.edu.au/~james/programs/mysql/

HTH,
Katherine