Gong has asked for the wisdom of the Perl Monks concerning the following question:

I have to use a general (i.e. not db specific) sql statment to update / inserts pictures in a database, what should i do? any site on sql talks about this?

Replies are listed 'Best First'.
Re: Blob in sql
by gmax (Abbot) on Apr 16, 2002 at 15:14 UTC
    BLOBs are db specific, I am afraid, so the only generalization you'll find is the DBI.
    The Super Search will tell you what is already in the pot.

    At your shell prompt, type
    perldoc DBI
    and search for "BLOB". There are some interesting points.

    For some inspiration on how to do it with MySQL, check this node.

    A database independent alternative is to store the images in external files, and have only the file name in your database. It is not my favorite solution, but you can find more on this subject at these nodes.
     _  _ _  _  
    (_|| | |(_|><
     _|