What are the recommended database column sizes for names? [closed]

Question

In regards to database design, what are the recommended column sizes for such fields as someones first, middle, and last name? Additionally, is the standard one character for a middle name safe, or should additional space be allowed for middle initials?

Specifically, I'm looking for sizes that will allow this be something I don't have to worry about for international usage. I have seen some middle initials that are two characters, so I doubt that a single character is a good idea, but I'm curious to see if there are any guidelines out there already.

Answer 1

ISO has not issued standards for naming of humans (yet), though I hear a preliminary draft is being passed around at the very highest levels.

:)

Seriously, 64 or so should be adequate for 99.99% of first and last names -- in any language. I've never seen anything other than one char for an MI (though you're right, many folks have more than one).

BTW: Unless I'm mistaken, email addresses -- technically -- can be up to 320 characters in length and can contain ! # $ % & ' * + - / = ? ^ _ ` { | } ~ and . provided that . is not the first nor last character, nor may it appear two or more times consecutively.

PS. My pet rabbit's name is "His Imperial Majesty Theopolops Bunny Galore". Needless to say this was truncated in the vet's database. I think they have it as "His Imperial Maj". So it goes.

Answer 2

You need 590 characters combined if you want to support the world's longest name.