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] Commented: (DERBY-102) can not insert more than 32270 charakters in long varchar, clob
Date Tue, 14 Dec 2004 07:34:55 GMT
     [ http://nagoya.apache.org/jira/browse/DERBY-102?page=comments#action_56626 ]
     
rainer garbotz commented on DERBY-102:
--------------------------------------

start the database:

java org.apache.derby.tools.ij connect 'jdbc:derby:C:/Temp/derby/db;create=true';

create table with

create table egal (
text CLOB(2M)
);

or 

create table egal (
text CLOB
);

and insert the data:

insert into egal values ('
dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd and so on...
');

I don't write alle the "d" charakters here! 

All Datatypes

VARCHAR
LONG VARCHAR
CLOB

seems to have the same limitation!

In derby.log File there is no error message. Please try it by yourself.

Regards
Rainer

> 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