db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "rainer garbotz (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-102) can not insert more than 32270 charakters in long varchar, clob
Date Mon, 13 Dec 2004 10:36:56 GMT
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  
 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.



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