how one uses binary large objects in their mysql databases?

By: Shailesh Singh | 05 Sep 2008 1:01 pm

Hello all,

I would like to ask how one uses binary large objects in their mysql databases?

Does this mean that I have to upload the blob (in my case some jpeg pictures) itself into the directory i am working in (i work under
linux). If I dump a database or table that the blob is embedded in, then does this mean I get a database within which i can view the jpeg image?

Thanks,

For better database performance, I would suggest storing the actual
JPEG files in a directory on the server somewhere and just storing the
filenames in MySQL.

By: PHP Guru | 05 Sep 2008