On 24/03/2023 07:38, Stanimir Stamenkov via derby-user wrote:
Thu, 23 Mar 2023 14:54:50 -0600, /Russell Bateman/:
In fact, experimentation seems to suggest that the breaking point is a
length of 32K+.
This seems to match the VARCHAR and LONG VARCHAR specifications:
* https://db.apache.org/derby/docs/10.16/ref/rrefsqlj41207.html
* https://db.apache.org/derby/docs/10.16/ref/rrefsqlj15147.html
This happens to be the string literal in your INSERT statement. If you
want to insert more than 32K in your CLOB column you would need to use
the JDBC interfaces:
Or:
INSERT INTO foo(id,myclob) VALUES(rownum,'32K of data');
UPDATE foo SET myclob = myclob || 'another 32K of data' WHERE id=rownum;
UPDATE foo SET myclob = myclob || 'yet another 32K' WHERE id=rownum;
and so on.
--
John English