--- In firebird-support@yahoogroups.com, Eugen Stoianovici
<eugen.stoianovici@...> wrote:

>
> Alan McDonald wrote:
> >> Is there a text field defined for firebird?
> >> I need to store large text files (about 10-20k of text)...must i use
> >> blob fields or is there an other way?
> >>
> >>
> >
> > blob is the way.. is there a problem with that?
> > Alan
> >
>
> Blob is ok...it's just that with text i could have done some search in
> it before storing it on a local drive.

BLOB SUB_TYPE TEXT is equivalent to the text fields in other RDBMS.
You can use =, Like, Containing etc with BLOB SUB_TYPE TEXT.

Adam