We have a couple of field names on the DB with size of varchar(50).
Those fields are fullname and emailAddress
It turns out that some users have names with values longer than size 50.
Same with emailAddress.
So, when some users with names or email addresses larger than 50, they get truncation error.
Can you please recommend the best solution for this?
For starters, I increased the fieldname size to 100 each.
However, management thinks more needs to be done to prevent user from seeing that error message, like give user custom message.
Any thoughts if she is right?
If yes, any ideas how to proceed?