> Hello,
> I'm trying to convert a database from Access2000 to Firebird 1.02.
>
> One table has the datatype MEMO which can hold a string up to 64k
> long.
> What datatype can I use in Firebird ?
> What is the maximum length for a VarChar ?
> ((Maybe I'm blind but) I didn't find that in the DataDef. Guide)
>

You can use a VarChar field if you know that the amount of information is
always going to be limited. However, it is probably better to use a BLOB
field of Sub_Type Text. That would allow you to store an unlimited amount of
information, such as the memo field does in Access or Paradox.

Woody (TMW)

"Start every day off with a smile and get it over with."
-- W. C. Fields