Storing images in MySQL db -- type? [duplicate]

Question

Possible Duplicate:
Is it better to store images in a blob or just the url?

I need to recover images from an XML file stored on a remote server and save it to my database. Not sure how I should do so though, what type of field should the image be stored in?

Thanks!

Answer 1

You can store your images as blobs, but in practice you're usually better off storing them in the file system and just keeping the paths to the images in the database.

See: MySQL Docs: BLOB datatype

Answer 2

You would just store the src in a varchar field, if using php do a file get contents function and use the awesome string functions to parse the file.