Max Length on String Field ?

[sukran]

I have a request to increase the string field value from 80 to 500 in the problem table

If i change it took more time and doesnt change to 500

Is this any global or data loss impact will happen ? or how to achieve this

[sukran]

After increasing the size up-to 500 and save , The page has hang for some time with blank screen and value of 500 not updated in the column , its shows same 80 only.

Shall i delete the column and create new one ?

[Anurag Tripathi · Accepted solution]

Deleting will make you loose the data.

What you can do is...create a new column...with length 500. then copy the data from old fiedl to new, and then delete the old field.

[sukran]

Yes we can create new one with 500 maximum length value