db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Barnet Wagman <b.wag...@comcast.net>
Subject Re: Max size of LONG VARCHAR documentation inconsistency?
Date Sat, 12 Feb 2005 19:53:26 GMT

> 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