cjb Posted March 24, 2006 Share Posted March 24, 2006 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? Link to comment https://forums.phpfreaks.com/topic/5723-searching-binary-blob-data/ Share on other sites More sharing options...
redarrow Posted March 24, 2006 Share Posted March 24, 2006 [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. Link to comment https://forums.phpfreaks.com/topic/5723-searching-binary-blob-data/#findComment-20416 Share on other sites More sharing options...
cjb Posted March 25, 2006 Author Share Posted March 25, 2006 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? Link to comment https://forums.phpfreaks.com/topic/5723-searching-binary-blob-data/#findComment-20540 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.