• 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

Text search on a BLOB

 
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 83
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Do not threaten THIS beaver! Not even with this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic