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?