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? Quote 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. Quote 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? Quote Link to comment https://forums.phpfreaks.com/topic/5723-searching-binary-blob-data/#findComment-20540 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.