You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by Ryan Dewell <ry...@dewell.org> on 2005/02/11 03:49:56 UTC
Max size of LONG VARCHAR documentation inconsistency?
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
Re: Max size of LONG VARCHAR documentation inconsistency?
Posted by Kathey Marsden <km...@sbcglobal.net>.
That should work fine it would be BLOB's over 2G that would be problematic.
Barnet Wagman wrote:
>
>> 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
>>
> Does this mean that e.g.
>
> CREATE TABLE XXX ( ABLOB BLOB (256M) )
>
> won't work? If so, this is a VERY serious problem. I think I have
> tested this and I /thought/ it worked.
>
> bw
>
Re: Max size of LONG VARCHAR documentation inconsistency?
Posted by Barnet Wagman <b....@comcast.net>.
> 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
>
Does this mean that e.g.
CREATE TABLE XXX ( ABLOB BLOB (256M) )
won't work? If so, this is a VERY serious problem. I think I have
tested this and I /thought/ it worked.
bw
Re: Max size of LONG VARCHAR documentation inconsistency?
Posted by Sunitha Kambhampati <ks...@gmail.com>.
Ryan Dewell wrote:
>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"
>-------------
>
>
>
>
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,
Sunitha.