I thinks besides the question of good design, the length of any field is also a part of business rules. For example, it may be a rule that name will be maximum 30 characters or address line be 3 lines of 70 characters each etc.

When the rule is not compilied with, the insert in row should fail. Without this discpilne, it is quite possible that anything goes inside database.

Kailash Pareek