[ http://issues.apache.org/jira/browse/DERBY-102?page=history ]
Daniel John Debrunner updated DERBY-102:
----------------------------------------
Component: Documentation
(was: SQL)
Changed to documentation bug.
> 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
>
> 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
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
