SA> What would be the nearest match for Memo type in Access? SQL2GDB converted it as
SA> BLOB. But Java handles BLOBs completeley differently than Memo types (these are just
SA> long strings with a max. cap of 32K). Anyone with ideas?

VARCHAR in FB can be 32K long :)

By the way, you may access BLOBs with getString and setString, so it
makes no difference compared to CHAR/VARCHAR fields.

best wishes,
daniel