The article probably meant that the optimization that can occur with text
columns with an index will not take place with a blob column. But, it will
still work on it. Besides, when dealing with BLOB columns CONTAINING is the
one I use most.

Actually, I use a fuzzy text searching module that is new with IBO version
4. It allows full text searching with very optimized access. I use
replication to store the full text search index in a separate database so
that it won't bloat things too much. It works really great and is easy to
setup.

Here's a web-site that I did which will show you how it works. This is a
list of corporation names, partnership names, tradenames, etc. The law reads
that there cannot be any names *deceptively* similar to another name. So, I
had the challenge of writing a name search algorithm to try and find things
which are deceptively similar.

Use some creative searches in the name (not agent name) to see how it does.
Try using some of the other search options like soundex, metaphone, etc.

http://www.sosaz.com/scripts/TNT_Search_engine.dll/

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Peter Morris" <pmorris@...>
To: <IBDI@yahoogroups.com>
Sent: Wednesday, June 06, 2001 3:57 PM
Subject: Re: [IBDI] Re: Internet


> > I have no idea how you took my comments regarding security issues on
port
> > 3050 and suggest adding a memo type. There is a memo type filed in
> Interbase
> > that does support LIKE.
> >
> > I think you may have answered someone else's question on this email.
Just
> > making sure.
>
> hehe
>
> I was pretty vague :-)
>
> > > I think part of the requirement to achieve this would be to add a memo
> > field
>
> What I meant by that was "One of the requirements of making an internet DB
> would be to add a memo type field"
>
> You say there is already a memo type field that supports LIKE ? What is
it
> ?
> I read that setting the SUB_TYPE of a blob to text still does not support
> LIKE, was that article incorrect or is there another type I am unaware of
?
>
> Pete
>
>
> Community email addresses:
> Post message: IBDI@yahoogroups.com
> Subscribe: IBDI-subscribe@yahoogroups.com
> Unsubscribe: IBDI-unsubscribe@yahoogroups.com
> List owner: IBDI-owner@yahoogroups.com
>
> Shortcut URL to this page:
> http://www.yahoogroups.com/community/IBDI
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>