It is common to check if entered password is at least # characters long, or if user input is not left empty. However, I see a few websites testing if user input is not unusually long.
Typical (MySQL) database design will dedicate 100-255 characters for e.g. to first name, last name input. Longer input will cause loss of data. What is the recommended way of handling abnormal input as such?