Menu
50 characters (of which 15-25, depending on layout, are visible in the form input field) for the family name should be plenty.
I would say for names (first or last), go at least 50 chars, and for email address, make it at least 128.
dBase table field names have a ten-character limit, so the raster attribute tables also have a ten-character limit.
People will run into the following character limits when they fill out an Address field: Street Address: 255 characters. Address Line 2: 150 characters. City: 255 characters.
UK Government Data Standards Catalogue suggests 35 characters for each of Given Name and Family Name, or 70 characters for a single field to hold the Full Name.
I know I'm late on this one, but I'll add this comment anyway, as others may well come here in the future with similar questions.
Beware of tweaking column sizes dependent on locale. For a start, it sets you up for a maintenance nightmare, leaving aside the fact that people migrate, and take their names with them.
For example, Spanish people with those extra surnames can move to and live in an English-speaking country, and can reasonably expect their full name to be used. Russians have patronymics in addition to their surnames, some African names can be considerably longer than most European names.
Go with making each column as wide as you can reasonably do, taking into account the potential row count. I use 40 characters each for first name, other given names and surname and have never found any problems.
I usually go with varchar(255) (255 being the maximum length of a varchar type in MySQL).
If it's full name in one field, I usually go with 128 - 64/64 for first and last in separate fields - you just never know.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With