• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Search BLOB for text

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I have around 7000 blob records containg word Doc's.(Its increasing ...)
I need a text search on this BLOB feild.
I am considering two options as of now:
1. store all the BLOB into the local File system of the App Server and use file search.i.e create a file object and loop and search.Thus every time i insert a new blob from application i do it on the server FS and in the DB.

2. Write a proc in the DB where i loop and the blobs and search my text.(I dont know how..)

Any Help would Be greatly Appreciated...
Thanks in Advance.
 
Marshal
Posts: 28260
95
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Your main problem is not that the data is in a BLOB, but that the data is in MS Word format. To search for text in the documents, you must have code that understands MS Word format. And Java code that does that is not easy to find (and don't even think of trying to write it yourself if you have to ask this question).

It's possible that Open Office has something that could help you.
 
reply
    Bookmark Topic Watch Topic
  • New Topic