推荐的数据库列大小是什么？ [英] 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.

：）

对于任何一种语言，严重的是，对于一个或多个姓氏的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).

BTW：除非我错了，电子邮件地址 - 技术上可以长达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。我的宠物兔子的名字是他的陛下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屋！