can not insert more than 32270 charakters in long varchar, clob
---------------------------------------------------------------
Key: DERBY-102
URL: http://nagoya.apache.org/jira/browse/DERBY-102
Project: Derby
Type: Bug
Components: SQL
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://nagoya.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
