At 01:01 PM 28/06/2004 +0000, you wrote:

>Hi
>
>I am just in the process of converting my paradox based apps to
>firebird. I have a several 'memo' fields in the paradox table, but
>there doesnt seem to be an equivalent data type in Firebird.

BLOB SUB_TYPE 1 (or BLOB SUB_TYPE TEXT)

>Do I use varchar?

Why? the Paradox Memo type is a text BLOB.

>What is the max size of a varchar field?

Depends on the character set. For character sets NONE, OCTETS, and
single-byte international sets, it is 32,765 bytes. For multi-byte
character sets the maximum varchar sizes are fractions of that number.

Helen