db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: ALTER TABLE __ ALTER COLUMN Data type syntax
Date Wed, 10 Jan 2007 17:00:52 GMT
> "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



Mime
View raw message