Alex Moots wrote:
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
I think in this case the problem is that you can't change a VARCHAR
to a CHAR using ALTER TABLE .. ALTER COLUMN. You can only change
a VARCHAR to another (longer) VARCHAR.
In the next release, you'll be able to use the techniques described
in DERBY-1515 (http://issues.apache.org/jira/browse/DERBY-1515) to
make more substantial changes to a column's datatype in a dynamic fashion.
thanks,
bryan
