数据库:gbase8t
问题:
原来的列desc类型是TEXT类型,现在想换成lvarchar类型,语句如下:
alter table customer modify(desc lvarchar(512));
执行时报错信息如下:
SQL 错误 [ErrorCode : -9633] [SQLState : IX000] : ALTER TABLE can not modify column (desc) type. Need a cast from the current type to the new type.
ALTER TABLE can not modify column (desc) type. Need a cast from the current type to the new type.
java.sql.SQLException
有大牛知道这个问题怎么解决吗?
收起