Re: jpgs into database

* Jasper Bryant-Greene <jasper@bryant-greene.name> : > George B wrote: > > is it possible to put in a jpg file into a database? I am trying to make > > like a catalong and have all the files (including pics) and everyone can > > see. > > is this possible? > > Sure -- if you're using a MySQL database, just use a BLOB field and put > the data in as you would a string of text. Be aware of your storage requirements, however. There are several BLOB types -- TINYBLOB, BLOB, MEDIUMBLOB, and LONGBLOB -- so make certain you choose the one that exceeds the maximum file size you expect to place in the DB. Additionally, there are performance hits to storing images in a database. Another approach that is widely used is to store the images on the filesystem, and then image *details* -- location, size, caption, photographer, etc. -- in the database. This is typically faster, and will reduce the number of DB calls. -- Matthew Weier O'Phinney Zend Certified Engineer http://weierophinney.net/matthew/