db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kathey Marsden <kmarsdende...@sbcglobal.net>
Subject Re: Max size of LONG VARCHAR documentation inconsistency?
Date Sat, 12 Feb 2005 19:04:58 GMT
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
>


Mime
View raw message