数据库设计问题 - 存储国际人名
据我所知，名字姓氏“问题”是使用美国人设计的网站的人们经常抱怨的问题。您认为什么是适合更多国家的更好的系统？您建议使用哪些字段来存储名称可能需要访问、理解或显示的各种方式？
根据系统的用途，我会根据美国的 FirstName MiddleName 和 LastName 理念提出以下字段。中间名在美国几乎不被使用，但大多数人都有一个。它可以帮助区分具有相同名字姓氏组合的许多人。
FirstName : George
MiddleName : Henry
LastName : Davis
DisplayName : George D.
Alias : Kidd1985
LegalName : George Henry Davis
显然，我的设计可能存在一些缺陷，因为 LegalName 包含与其他字段相同的数据。但是，我怀疑在某些情况下无法从其他字段派生出 LegalName。
但现在我很好奇你们会向国际观众推荐什么系统？
I understand that the FirstName LastName "problem" is a frequent complaint of people who use websites designed by Americans. What do you think is a better system that will suit more countries? What fields would you recommend using to store the various ways that a name might need to be accessed, understood, or displayed?
Depending on what the system is for I would propose the following fields based on the US idea of FirstName MiddleName and LastName. Middle names are almost unused in the US but most people have one. It can help differentiate between the many people who share the same combination FirstName LastName.
FirstName : George
MiddleName : Henry
LastName : Davis
DisplayName : George D.
Alias : Kidd1985
LegalName : George Henry Davis
Obviously, there are probably some flaws with my design since LegalName contains the same data as the other fields. However, I suspect there are cases where the LegalName cannot be derived from the other fields.
But now I'm curious what system you all would recommend for an international audience?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
啊哈。对此没有“正确”的答案，但有很多雷区和装满蠕虫的罐子......
你有名字，姓氏，姓氏，基督教名，家族名，父名，部落名，中间名，缩写，头衔，少女姓名、辈分、职业名称……？ 这里有一个例子
还应该阅读这些“程序员相信关于名字的谎言” 和 "姓氏在前"
基本上，你必须选择一个涵盖 80% 可能性的方案。
例如，我的全球公司数据库中有一家总部位于西欧的公司的名字和姓氏：它满足我的需要，无论它在更广泛的意义上是否正确。
编辑，2013 年 3 月。
更多官方非博客来自 W3Org 的官方指导
Ah ha. There is no "proper" answer to this but plenty of minefields and cans full of worms...
You have first name, last name, surname, christian name, family name, patronymic, tribal name, middle name, initials, title, maiden name, generational name, occupational name, ...?. An example here on SO
You should also read these "Falsehoods Programmers Believe About Names" and "Last Name First"
Basically, you have to pick a scheme that covers, say, 80% of possibilities.
For example, I have firstname and lastname in my global corporate database for a company with HQ in Western Europe: it does what I need whether it is correct in the wider sense or not.
Edit, Mar 2013.
More offical, non-blog official guidance from W3Org