Actually, blobs are stored in files in data directory. You can store your
binary files in data directory, if you wish.
----- Original Message -----
From: Gerald R. Jensen <[EMAIL PROTECTED]>
To: clay bond <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, February 17, 2001 5:52 PM
Subject: Re: is it possible to store images in mysql db?
> 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
>
>
---------------------------------------------------------------------
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
