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
*
In fact, experimentation seems to suggest that the breaking point is a
length of 32K+. Whether or not the length of the rest of the INSERT INTO
statement counts I do not know for certain, but the delta between
MsgContent and the rest is negligeable, so I don't care.
On 3/23/23 13:02, Russell
According to what I'm reading, a CLOB should easily hold more than the
128K I'm trying to put into it.
My table schema:
private static final StringTABLE_SCHEMA ="\n" +" MsgId BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY,\n" +" MsgContent CLOB DEFAULT NULL,\n" +" MsgReceived TIMESTAMP NOT NULL
