Subject | What leads to "New size specified for column X must be at least Y character" ? |
---|---|
Author | fxam |
Post date | 2005-02-06T15:46:23Z |
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 ?
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 ?