Error while increasing Max Length

puneetgoels1
Tera Guru

I have a custom field in incident table which was initially created to 50 characters but we have a new requirement to change its length to 4000. When I am trying to do that I am getting the below error 

Syntax Error or Access Rule Violation detected by database (BLOB/TEXT column 'a_str_16' used in key specification without a key length)

 

however I have an import set table to incident with same field, when I am trying to update length there, It gets updated without any fuss. Not sure Why?

5 REPLIES 5

Doesn't work