Subject What leads to "New size specified for column X must be at least Y character" ?
Author fxam
Hi,

I have a table with two columns:
-Column A (Char,5,ASCII)
-Column B (VarChar,1000,UNICODE_FSS)

I tried to changed size of Column B to 500, but Database Workbench says:
"ISC ERROR CODE:335544351
ISC ERROR MESSAGE:
unsuccessful metadata update
New size specified for column WORD must be at least 3000 characters."

To try things out, I followed and input 3000 and altered the table
successfully.
Now I want to change it to 500 again, and it now says:
"ISC ERROR CODE:335544351
ISC ERROR MESSAGE:
unsuccessful metadata update
New size specified for column WORD must be at least 9000 characters."

What is happening ?