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  
    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


Mime
View raw message