Jump to content


Photo

Searching Binary Blob Data


  • Please log in to reply
2 replies to this topic

#1 cjb

cjb
  • Members
  • Pip
  • Newbie
  • 6 posts

Posted 24 March 2006 - 10:17 PM

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?



#2 redarrow

redarrow
  • Members
  • PipPipPip
  • Advanced Member
  • 7,308 posts
  • Locationlondon

Posted 24 March 2006 - 10:54 PM

[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.

Wish i new all about php DAM i will have to learn
((EMAIL CODE THAT WORKS))
http://simpleforum.ath.cx/mail2.inc
((PAYPAL INTEGRATION THAT WORKS))
http://simpleforum.a...aypal1_info.inc

#3 cjb

cjb
  • Members
  • Pip
  • Newbie
  • 6 posts

Posted 25 March 2006 - 02:03 PM

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?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users