[ http://nagoya.apache.org/jira/browse/DERBY-102?page=comments#action_56627 ] Sunitha Kambhampati commented on DERBY-102: -------------------------------------------
Dan replied to this on the derby developer list. Please check out the link below incase you are not subscribed to the derby developer list:- http://nagoya.apache.org/eyebrowse/[EMAIL PROTECTED]&msgNo=1354 summary of it is:- String constants (literals) in the text of a SQL statement are limited in length. But if you use parameter markers '?' then you should be able to insert values with the below limits (as already stated in previous comment). VARCHAR maximum length 32 672 LONG VARCHAR maximum length 32 700 CLOB maximum length 2 147 483 647 BLOB maximum length 2 147 483 647 > 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
