[jira] Commented: (DERBY-102) can not insert more than 32270 charakters in long varchar, clob

["Brian Bonner (JIRA)" <de...@db.apache.org>]

    [ http://issues.apache.org/jira/browse/DERBY-102?page=comments#action_12319029 ] 

Brian Bonner commented on DERBY-102:
------------------------------------

It seems like IJ should be able to support literals longer than 32770 characters.

Many people use scripts to initalize the databases.  the scripts don't normally use prepared statements.  Is this limitation related somehow to the the statement cache?

Thanks.

> can not insert more than 32270 charakters in long varchar, clob
> ---------------------------------------------------------------
>
>          Key: DERBY-102
>          URL: http://issues.apache.org/jira/browse/DERBY-102
>      Project: Derby
>         Type: Bug
>   Components: Documentation
>     Versions: 10.0.2.1
>  Environment: Windows XP/2000
>     Reporter: rainer garbotz
>     Priority: Critical
>      Fix For: 10.1.1.0

>
> I have created an table with
> create table egal (
> text long varchar
> );
> Now I try to insert an 38000 charakters long String.
> insert into egal values ('
> ......
> ');
> But there are following error message:
> ERROR 54002: A string constant starting with ''
> ddddddddddddddddddddddddddddddddddddddddddddddddddddddddd&' is too long.
> I tryed the same with CLOB, but the same error occures.
> The "Reference Manual" says to LONG VARCHAR:
> "The LONG VARCHAR type allows storage of character strings of unlimited length"
> Have I missunderstood this, or is this a BUG.
> Thanks
> Rainer

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira