OK I'm working on my conversion paper and need the 'current state of play'.

One of the conversion problems from MySQL is FULLTEXT search. This is
usually ignored, but I need an update on 'preferred practice' with FB1.5 :)

Is it still preferred to use a BLOB over a large VARCHAR, and can we
actually now search on BLOB - which I seem to remember came in sometime.

Second related problem. With a large VARCHAR can we index on a
SUBSTRING, or do we have to create a 'trimmed' field to use for the index.

Both of these I have managed to avoid by design, but need to be able to
answer the questions ;)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services