db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brenda Reyes (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-102) can not insert more than 32270 charakters in long varchar, clob
Date Tue, 01 Mar 2005 21:49:48 GMT
     [ http://issues.apache.org/jira/browse/DERBY-102?page=comments#action_59997 ]
Brenda Reyes commented on DERBY-102:

I fixed this in the contributed DITA source files for the Derby Reference Manual and gave
the changed file to Jeff Levitt, who is currently working on the DITA files as well.  I wanted
to avoid overiding his changes.  I ran this change by Sunitha, and she says it looks good,
so once the Manual is sent to Jean again by Jeff, please check and close this bug if everything
looks good!

> 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:
>  Environment: Windows XP/2000
>     Reporter: rainer garbotz
>     Priority: Critical

> 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:
If you want more information on JIRA, or have a bug to report see:

View raw message