I know it's possible to search for text in blobs in oracle db. (Source)
But is it possible in hsql?
Yes, use LIKE, POSITION or regular expressions. See the built-in functions for different options.