Thanks for the quick response, but the query:
ALTER TABLE bl.USERSPROPERTIES ALTER COLUMN Value SET DATA TYPE CHAR(32000)
Still gives me the same error message:
The length, precision, or scale attribute for column, or type mapping
'CHAR(32000)' is not valid
The documentation at:
file:///D:/java/db-derby-10.2.2.0-bin/docs/html/ref/rrefsqlj13733.html
should probably be updated if CHAR's length is limited to ~32000.
Alex.
Bryan Pendleton wrote:
"The length, precision, or scale attribute for column, or type
mapping 'VARCHAR(1000000)' is not valid."
Varchar is definitely limited to 32 thousand bytes as its max length,
see: http://db.apache.org/derby/docs/dev/ref/rrefsqlj41207.html
If you really need a enormous length value, I think you need to
use a CLOB.
thanks,
bryan
--
Alex Moots www.BuilderLynx.com
Builder Lynx t: 416-425-2925 f: 416-425-4233
