Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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.

like image 268
rjzii Avatar asked Dec 03 '22 16:12

rjzii


2 Answers

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.

like image 177
PartialOrder Avatar answered May 30 '23 02:05

PartialOrder


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

like image 25
Jeb Avatar answered May 30 '23 02:05

Jeb