But yes. Programmers have a hard time using unicode. It's a shame not all programming languages use unicode.
I also think is has to do with bad research. It isn't hard to check different types of family names and naming order.
There are a lot of countries where they place the family name first followed by there personal name.
I'm still trying to figure the best way to store names. Maybe 2 fields will fit all:
family_name (Spring in 't Veld)
name (Robert Spring in 't Veld)
Family name can be used for grouping and sorting. But you need to store the name as the user entered it. Don't try to split it in parts, just leave it as is.About to find myself building some such systems and would prefer to do it right…
Names are just Unicode strings, which you should not fold, spindle or mutilate. Why do you care which bit is the family name, or if this person has a family name, or even if there is such a thing as a family name in their family's culture? Why even try for a canonical form?
Even better, make name a _list_ of Unicode strings, so people who have multiple names (Chinese/Western, pre/post marriage, pre/post op) can give you the whole list to search on.
If asking for their credit-card details, ask "Name As Printed On This Credit Card" and store that as well so you can bill them. That's really a property of the card, not the person.
And then just add a "Informal Name" field so you're not stuck guessing which bit is the informal name, or writing "Dear Roderick Frederick Ronald Arnold William MacArthur McBan" which does sound kind of dorky ...
</rant>
- Many non-sanitized SQL queries fail,
- buggy URL or HTML parsers create code like:
- Pagetitles like: Spring in /'t Veld- Added smart quotes "Spring in ’t Veld" from Word or Rich Text Editors cause problems with sorting and identity consolidation.
- Stripping the quote character trips a 2-letter requirement.
- etc.
It is unlikely that people will name their son
But you should at least prepare your db queries for a quote. :)http://xkcd.com/327/