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

[Brian O_Donnell]

There should not be any problems changing the length of a string field from 80 to 500.   Problem is an extended table, so you might not be changing it only on that table - it could be on the table that it is extended from.   Data loss should not occur when increasing the size of a string field.   Did you receive any messages when you attempted the change?

[Adiseshu Borra]

HI balakrishnan,

try to check, is the field is Dictionary Overrides.

[Anurag Tripathi]

time it will take depends on how much data is present in that table, number of records as its an alter table command.

Data loss occurs if you change the type of field or decrease the length, in your case there should not be any.

[shloke04]

Hi,

Can you share the screen shot of the error you are getting while increasing the Field Length.

Increasing field length won't create any data loss but if you decrease the field length then Data Loss occurs.

Hope this helps.Mark the answer as correct/helpful based on impact.

Regards,

Shloke