> William Kerber wrote:
> >
> > Is it possible to store binary content such as programs, images, soundfiles
> > in a mysql database? Is anyone doing this successfully?
> >
> > Should I just be storing the location of the files?
>
> This depends. Yes MySQL supports binary fields but in case of
> images/audio/etc I suggest to use only names to store. I can't see any
> real advantages of putting them into SQL database.
I beg to differ on this point. There are good reasons to want to place
your media, or other substantial binary data, in the database. As far
as I know, the large blob type is fine for this purpose. There were
some issues with Java drivers, but I think they have been resolved.
tim.
Tim Endres - time@stripped
ICE Engineering, Inc. - http://www.ice.com/
"USENET - a slow moving self parody." - Peter Honeyman
