Subject Re: [ib-support] Sorting and Searching BLOB SUB_TYPE 1 fields
Author Helen Borrie
At 08:45 AM 25/03/2003 -0800, you wrote:
>I'm using Java + Firebird. I have some text fields that cannot be bounded
>by size and I'm wondering how I can efficiently sort or search on those fields.

For searching, you *can* use CONTAINING on blob sub_type 1.

You can't index or sort blobs. When I need sorting on blobs, I extract and
store keywords from the client side when inserting blob data. When the
text is e.g. a document of a set layout, this might be as simple as storing
the title in an indexed column. If you need multiple sorts, you can add
more structure and store other data relating to the blob content.