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. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)