Modify text, unitext, and image Columns

You can modify the text, unitext, and image columns with certain restrictions.

unitext columns can be converted to:

You cannot modify char, varchar, unichar, and univarchar datatype columns to text or unitext columns. If you are converting from text or unitext to char, varchar, unichar, or univarchar, the maximum length of the column is governed by page size. If you do not specify a column length, alter table uses the default length of one byte. If you are modifying a multibyte character text, unitext, or image column, and you do not specify a column length that is sufficient to contain the data, SAP ASE truncates the data to fit the column length.