At 04:26 PM 11/12/2002 +0100, Riste Pejov wrote:

>What is the best way to perform FULLTEXT search on blob column subtype 1 ?
>
>As far as i've seen in the documentation, there is nothing on fulltext
>search.
>
>Are there any workarounds for this problem, or i'll just have to use one big
>varchar(32000) field ?

Have you considered using LIKE or CONTAINING? Either will do a full
text search - LIKE is case sensitive, CONTAINING is not. However,
neither than nor a varchar field will help if you need an indexed
full text search. There are (at least) two products available that
will let you index terms in varchar and blob fields.

FastTextSearch/IB V1.5 A solution for searching textual information in an
InterBase database. Allows indexing on an unlimited amount string and
textual memo fields. By Andre N Belokon
Shareware

IBO Full Text Search Module Components for building server-side full text
(fuzzy) searching of long varchars and text blobs into your Delphi and
C++Builder applications. Module comes with components, help file and a
fully set-up module that can actually be used as a utility to set up the
search metadata in your databases. Source is supplied so the supplied
application also acts as a template for your own search implementation. By
Jason Wharton Trustware




Regards,

Ann
www.ibphoenix.com
We have answers.