Forums Register Login

Search BLOB for text

+Pie Number of slices to send: Send
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.
+Pie Number of slices to send: Send
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.
If you believe you can tell me what to think, I believe I can tell you where to go. Go read this tiny ad!
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 1400 times.
Similar Threads
Oracle text search
How do you convert an stream in to Blob data?
File Upload Problem
File-based persistence system is needed
regarding image insertion in database
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 11:14:42.