> This is sort of OT and not.
>
> BLOB is binary, don't think you need to specify twice:-) Take off the
> binary part.
>
> It doesn't matter on how you go about storing you images, both ways are
> fine.
As long as we are sort of on/off topic there is a question about
retrieving images that are stored in databases that I've always wanted
to ask.
Can you retrieve a database stored image and mix it in with regular
HTML?
It seems to me that if you are going to print an image, you would have
to print the Content type for images and would then be unable to print
regular HTML. Am I wrong there?
Jeff
> The only think you might want to think about is your service
> provider, if you are not running your own server. How much space due they
> allocate for your files and how much are you allowed to store in your db.
> >From my experience, providers (at least the ones I've dealt with) always
> limit your directory size, though they are not as limiting on your db, so
> you must evaluate these things and see what's a more efficient long term
> solution for you.
>
> Don't forget to set LongReadLen and LongTruncOk when retrieving images, and
> you must use placeholders when inserting them.
>
> Ilya
>
> -----Original Message-----
> From: Todd Moy
> To: dbi-users
> Sent: 9/7/01 10:32 AM
> Subject: Images in MySQL
>
> Hello all:
> Just a quick question concerning putting images in a database-
> I want to add a field for images within my mysql database: how should I
> go about doing this?
> I have tried
> --
> ALTER TABLE project
> ADD(proj_img blob binary);
> --
> ...to no avail. What is the correct syntax?
> Also, is this even a good idea? Would it be better to just store a link
> to an image within another directory? The images contained within should
> be under 100k.
