Subject Re: [ib-support] Access memo datatype equivalent
Author Daniel Rail
At 04/25/2002 11:25 PM, you wrote:
>What would be the nearest match for Memo type in Access? SQL2GDB converted
>it as
>BLOB. But Java handles BLOBs completeley differently than Memo types
>(these are just
>long strings with a max. cap of 32K). Anyone with ideas?

A text BLOB is a BLOB SUB TYPE 1. A CHAR or VARCHAR can contain up to 32K
characters, but that's also the maximum number of bytes allowed in a
record(the last I heard).

There are others on this list with Java experience that could tell you how
they handle them.

Daniel Rail
Senior System Engineer
ACCRA Group Inc. (
ACCRA Med Software Inc. (