I once saw someone on stackoverflow saying that it is recommended that when the length of the varchar field cannot be estimated, it is best to set it to an integer multiple of the encoding. For example, if the utf8 encoding is three bytes, then setting it to 255 is more appropriate. Is there any scientific basis for this?
I only know that the maximum length of varchar is 255
Prevent space waste and fragmentation
I think this is more appropriate.