Hi Ralf,

> I'm trying to convert a database from Access2000 to Firebird 1.02.

A wise decision ;-)

> One table has the datatype MEMO which can hold a string up to 64k
> long.
> What datatype can I use in Firebird ?

For this one, you can use a BLOB (see Data Definition Guide).

> What is the maximum length for a VarChar ?

The maximum length of a VARCHAR is 32765 characters
(if you use a one-byte collation).


HTH,
Christian