db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ryan Dewell" <r...@dewell.org>
Subject Max size of LONG VARCHAR documentation inconsistency?
Date Fri, 11 Feb 2005 02:49:56 GMT
Hello,

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.

-------------http://incubator.apache.org/derby/manuals/reference/sqlj137.htm
l#HDRSII-SQLJ-15147
says:
"The LONG VARCHAR type allows storage of character strings of unlimited
length"

http://incubator.apache.org/derby/manuals/reference/sqlj270.html#HDRSTRINGLI
MITS
says:
"Length of LONG VARCHAR	32,700 characters"
-------------

Thanks,

Ryan



Mime
View raw message