• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Text search on a BLOB

 
Tony May
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 83
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic