> I just tried out a blob field but Marathon and IBExpert both require the
> sub-type to be numeric, what is the no. for a text blob?

1.

or

CREATE TABLE TAB ( B BLOB SUB_TYPE TEXT );

Ivan