There are several fields that are common sense to use with a given standard. The W3C and some other has its recommendations, but the advice on this site are comprehensive. I have made an easy overview that I have made that suits my purposes.
I just quried my databases with thousands of customers in Norway and checked with checked with other people’s recommendations.
This is what I found:
Name of field | Min | Max |
---|---|---|
The maximum first name length was 46. I go with 50. | 2 | 50 |
Last name was similar to first name: 50. | 2 | 50 |
Full name is sum of the above | 4 | 100 |
2 x Street address maxes out at 95 characters. The long ones were all valid. I always use to address field. | 0 | 100 |
Postal Code (https://en.wikipedia.org/wiki/List_of_postal_codes. Use max 12 if storing dash or space) | 2 | 11 |
Telephone Number | 3 | 15 |
Email Address | 7 | 254 |
IP Address (incl ipv6) | 7 | 45 |
Hostname | 1 | 255 |
Domain Name | 4 | 253 |
HTTP(S) URL w domain name | 6 | 2083 |
Longitude | numeric | 9, 6 |
Latitude | numeric | 8, 6 |
Money | numeric | 19, 4 |