Hi Daniel,

> Java does not support blobs very well

Why not? You can - most probably, I haven't checked - read it
from your resultset as a string.

>, would you know the max size of a
> varchar?it may be a good replacement?

The max-size for a varchar is about 32765 characters or so. But
read this first:
http://www.volny.cz/iprenosil/interbase/ip_ib_strings.htm

> > > I'm presently converting a mysql database to a firebird 1.5 database.
> >MySQL
> > > has a text field type to go to 64k. what should I be using with

firebird,

> > > to get the same functionality?
> > >
> > > can someone give me a suggestion, please
> >
> >BLOB subtype TEXT.
> >
> >Up to lots of Gigs...

With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com