db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alex Moots <a...@builderlynx.com>
Subject Re: ALTER TABLE __ ALTER COLUMN Data type syntax
Date Wed, 10 Jan 2007 17:05:48 GMT
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


Mime
View raw message