Actually ... there are often some good reasons one might want to store
pictures in BLOBs.
For example, our integrated application gives the administrators at our
various customer sites the ability to associate a series of icons on a
toolbar with a wide range of programmable functions. In addition to the
functions themselves, we want the customer's Administrator to be able to
associate standard .ICO or .BMP icon graphics with the various toolbar
positions and the functions they have decided to associate with them.
We also want the customer's Administrator to be able to use standard icon
graphic editors to create their own pictures, and use our utility program to
slam them into the BLOB.
If we store them as seperate binaries, then we have to keep track of the
path to them. On an NT network, any goofball (usually with Admin privs!) can
use Explorer to find/move/delete these files. If we store them as BLOBs in
the database, we know exactly where they are.
G. Jensen
----- Original Message -----
From: "clay bond" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 17, 2001 8:16 AM
Subject: Re: is it possible to store images in mysql db?
>
>
> On Sat, 17 Feb 2001, Nikhilesh Haval wrote:
>
> > I want to store different file formats in a database like images (*.jpg)
> > or audio files (*.mp3). Is it possible to do so in mysql?
>
> >
> Yeah, that's what BLOB is for--but why would you want
> to do that? Why not just store the path in the table,
> and the binary somewhere else?
>
> --
> /"\
> \ / ASCII RIBBON CAMPAIGN
> X AGAINST HTML EMAIL
> / \ AND POSTINGS
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
