in reply to Hex format conversion in Perl

I know that in MySQL you can actually store binary data directly in blob fields... however I also know that whenever someone asks they are always told it is better to keep the items in files and just store their location in the database...
                - Ant

Replies are listed 'Best First'.
Re: Re: Hex format conversion in Perl
by spaz (Pilgrim) on Apr 19, 2001 at 21:53 UTC
    Most SQL92 compliant databases have a BLOB type which will store binary data.
    I wish I could ++ you again, storing the path to the file on disk is 99.999% of the time a Good Thing

    -- Dave
      Yeah... there have been times I've wanted to give people a better vote... since there are some answers that solve the problem, and some that solve the problem while teaching... or some that just have lots of good points, etc...
      oh well... this site is quite well set up as it is, which I'm sure has taken A LOT of hard work. :)
                      - Ant