| Subject | Re: [ib-support] Sorting and Searching BLOB SUB_TYPE 1 fields |
|---|---|
| Author | Helen Borrie |
| Post date | 2003-03-25T21:53:55Z |
At 08:45 AM 25/03/2003 -0800, you wrote:
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.
heLen
>I'm using Java + Firebird. I have some text fields that cannot be boundedFor searching, you *can* use CONTAINING on blob sub_type 1.
>by size and I'm wondering how I can efficiently sort or search on those fields.
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.
heLen