Jump to content

Archived

This topic is now archived and is closed to further replies.

cjb

Searching Binary Blob Data

Recommended Posts

Does anyone know of any good tutorials of searching a MySQL blob field of binary data. I have multiple types of files uploaded (.doc, .xls, .pdf). Is there a way to search this data with PHP?

Share this post


Link to post
Share on other sites
[a href=\"http://www.zend.com/zend/tut/tutorial-ferrara1.php\" target=\"_blank\"]http://www.zend.com/zend/tut/tutorial-ferrara1.php[/a]

good luck.

Share this post


Link to post
Share on other sites
Thanks for the tutorial.

It suggest that you change any blog data types to text making it searchable. Does this mean you cannot search binary data? The only downfall of using text compared to longblob is the maximum length. I have large files to store in the DB and I don't think text will be enough.

Any other suggestions?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.