This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft on-line!
See this thread for details.
The moose likes JDBC and the fly likes Text search on a BLOB Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Text search on a BLOB" Watch "Text search on a BLOB" New topic
Author

Text search on a BLOB

Tony May
Greenhorn

Joined: Jan 04, 2002
Posts: 17
Is it possible to do a text search on a BLOB field?
If so, some pointers would be appreciated
Kind regards
Tony
Kevin Mukhar
Ranch Hand

Joined: Nov 28, 2000
Posts: 83
Technically, no. A BLOB is a BINARY Large Object. Blobs are usually not used to store text, thus it really doesn't make sense to do a text search on a blob.
Of course, there could be text embedded in the blob, such as track data in an mp3. But still, I doubt any database supports text searching in a binary large object. To do this, you will probably need to stream the binary data and search it yourself.
The other kind of LOB is a CLOB, character large object. Whether or not you can do a text search on a CLOB will be database dependent. I know Oracle 9i supports some string functions for CLOB data. You will need to check your specific database to see if you can do text search on a CLOB.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Text search on a BLOB
 
Similar Threads
Oracle text search
Search BLOB for text
Searching a document contents stored in database
inserting images into an oracle database
how to download a zip file from database?