db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sunitha Kambhampati <ksunitha...@gmail.com>
Subject Re: Max size of LONG VARCHAR documentation inconsistency?
Date Fri, 11 Feb 2005 04:30:52 GMT
Ryan Dewell wrote:

>The documents provide two different definitions of the max size of LONG
>VARCHAR.  One is 32k, and the other is unlimited.  Does anyone know the real
>limit of LONG VARCHAR?  I'm looking for a column type similar to
>Postgresql's TEXT.
>"The LONG VARCHAR type allows storage of character strings of unlimited
>"Length of LONG VARCHAR	32,700 characters"
The documentation is incorrect where it says maximum length is 
unlimited. There is actually a jira entry for documentation that is yet 
to be fixed.   http://issues.apache.org/jira/browse/DERBY-102

The actual maximum lengths are
VARCHAR maximum length 32 672
LONG VARCHAR maximum length 32 700
CLOB maximum length 2 147 483 647
BLOB maximum length 2 147 483 647

maybe a clob will work if you need length more than 32k.

Hope this helps,

View raw message