名称的推荐数据库列大小是多少? [英] What are the recommended database column sizes for names?

问题描述

关于数据库设计，对于某人的名字、中间名和姓氏等字段，推荐的列大小是多少?此外，中间名的标准一个字符是否安全，或者是否应该为中间名首字母留出额外的空间?

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.

推荐答案

ISO 尚未发布人类命名标准(目前)，不过我听说最高级别正在通过初步草案.

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.

:)

说真的，64 左右应该足以容纳 99.99% 的名字和姓氏——在任何语言中.我从来没有见过除了一个字符以外的任何 MI 字符(虽然你是对的，但很多人不止一个字符).

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).

顺便说一句:除非我弄错了，否则电子邮件地址 - 从技术上讲 - 最多可以包含 320 个字符，并且可以包含 !#$% &' * + -/= ?^ _ ` { |} ~ 和 .前提是 .不是第一个也不是最后一个字符，也不能连续出现两次或多次.

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.我的宠物兔的名字是His Imperial Majesty Theopolops Bunny Galore".不用说，这在兽医的数据库中被截断了.我认为他们将其称为他的帝国少校".就这样吧.

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.

这篇关于名称的推荐数据库列大小是多少?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！