manage image in mysql data

[Anon]

please help me..is it possible to keep image in mysql...???if possible how to do that??
thanks

[herve]

Yes you can do that. Use the BLOB type
to store the data of the image or
MEDIUMBLOB depending of the size
of your images.

[tasistro]

I would recomend using a varchar type to store the location of the image and then retrieve it using that path. Why?
-it makes the dbase smaller
-it makes queries smaller too, imagine the possible sizes of those results
-once you get the data from the blob you have to output the file to the browser. let the browser do that by itself, generate html with <img src="%your varchar string here">
-if the file sits on the servers file system you can edit it and work with it in ways you can't if its inside the dbase (ImageMagick for example)

Saludos
Gerardo