TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

My last name is correct and your DB validation is stupid

38 点作者 tarahmarie大约 12 年前

27 条评论

a-priori大约 12 年前
Names are complicated, very personal, and vary a lot depending on the culture. In English-speaking North America we're actually spoiled that most people have names that follow a standard given-middle-family convention. And also that one's given name is the same in all contexts.<p>But not everyone's name follows the same format. My wife has two middle names, one of my friends has three middle names, his wife has two given names and a middle name, and my father-in-law goes by his middle name.<p>And this convention is not true everywhere. Wikipedia has a list of articles for how names work in various cultures:<p><a href="http://en.wikipedia.org/wiki/Personal_name#Naming_convention" rel="nofollow">http://en.wikipedia.org/wiki/Personal_name#Naming_convention</a><p>As an example, here's how it works in Russia (note the diminutive form, where the given name depends on the social status of the person they're addressing):<p><a href="http://en.wikipedia.org/wiki/Russian_personal_name" rel="nofollow">http://en.wikipedia.org/wiki/Russian_personal_name</a><p>Of course, in lots of parts of the world, especially east Asia (e.g. China, Korea) it's common to put the family name first.<p>In general, the answer to "What is your name?" is "Who's asking and why?". If you need a person's name, you should ask for it in one of three ways:<p>1) What is your full, legal name? (e.g. Jonathan Anthony Smith Jr.)<p>2) What should we normally call you? (e.g. Jon, Mr. Smith, Johnny, Tony, Junior)<p>3) What name should we use when billing your credit card? (e.g. Jonathan A. Smith)<p>You should only ask the ones you need (don't need a full name? don't ask), and they should all of these should be free form with generous length limits and accept any Unicode text.
sp332大约 12 年前
This is an important topic, but the article is needlessly sexist. It pretty much assumes that men don't have hyphens or spaces in their names, even though her husband does. Women might have (a lot) more trouble with this than men, but jumping to the conclusion that there must not be any women on the Comicon website team is unwarranted. Also she explicitly calls "single capitalized word" names "heteronormative" which doesn't make any sense at all.
评论 #5714256 未加载
aed大约 12 年前
Relevant patio11: <a href="http://www.kalzumeus.com/2010/06/17/falsehoods-programmers-believe-about-names/" rel="nofollow">http://www.kalzumeus.com/2010/06/17/falsehoods-programmers-b...</a><p>I'd love to seem some kind of standardization around this. Perhaps the "persons" table doesn't have the name but rather the name is stored on a "names" table with an EAV model allowing for all kinds of conventions.
评论 #5714194 未加载
评论 #5714265 未加载
评论 #5714421 未加载
AncientPC大约 12 年前
Cache version:<p><a href="http://webcache.googleusercontent.com/search?q=cache:http%3A%2F%2Fthecowgirlcoder.com%2F2013%2F05%2F15%2Fmy-last-name-is-correct-and-your-db-validation-is-stupid%2F" rel="nofollow">http://webcache.googleusercontent.com/search?q=cache:http%3A...</a>
评论 #5714170 未加载
mseebach大约 12 年前
You make quite a point out of this being a problem for women. But presumably your husband (whose last name I assume is Van Vlack?) has the exact same problem?
onemorepassword大约 12 年前
Sidenote: afaik, "Van Vlack" is not a "Dutch" name.<p>Inappropriately adding the "Van" (which in Dutch is written with a lowercase v) is typically something Americans of Dutch origin did to make their name sound more interesting to Americans.<p>But for those looking to process Dutch names (or other cultures with similar construct), those names are sorted by the part behind the "van", i.e., "Jan van den Brink" (yes, it gets more complicated) will expect to find his name under "B".
评论 #5715438 未加载
manacit大约 12 年前
As someone with a Dutch "Van *" last name, I run into this issue all the time as well. Unlike the author, it doesn't upset me, I don't really care.<p>Sure, I was a little worried when the guy at the DMV warned me that the California system would always register my name wrong -- adding 'Van' as part of my last name along with my middle name. He told me to just mention it and everything would be fine.<p>Sure, it was pretty annoying the next time I went into the DMV and the guy blew me off, saying the system was fine. Sure enough, a few weeks later, my license arrived in the mail, incorrect. Unfortunately, they won't change it unless I bring them a passport or a birth certificate and pay to get it fixed, but it's not the end of the world. That change has persisted, and now my Washington State license still has my wrong name. Oh well.<p>Because my last name is much longer then the author's - 27 characters including spaces - it's been truncated since Kindergarden, and my University ID is still misprinted. Oh well.<p>I guess my point is that it's not the end of the world, there are bigger fish to fry.
评论 #5714439 未加载
post_break大约 12 年前
Stating you bought your twitter handle is a quick way to get your account deleted.
评论 #5714262 未加载
kimagure大约 12 年前
Google cache: <a href="http://webcache.googleusercontent.com/search?q=cache%3Ahttp%3A%2F%2Fthecowgirlcoder.com%2F2013%2F05%2F15%2Fmy-last-name-is-correct-and-your-db-validation-is-stupid%2F&#38;oq=cache%3Ahttp%3A%2F%2Fthecowgirlcoder.com%2F2013%2F05%2F15%2Fmy-last-name-is-correct-and-your-db-validation-is-stupid%2F" rel="nofollow">http://webcache.googleusercontent.com/search?q=cache%3Ahttp%...</a><p>Sorry if my URL has extra stupid bits, I don't do this often
tarahmarie大约 12 年前
Sorry about the site being down; give me a minute to bring it back up.
评论 #5714129 未加载
评论 #5714082 未加载
mirkules大约 12 年前
I also wish we had a way to include "special"[1] characters in names. My name would have a "ć", so I could never spell it correctly and had to anglicize it. I guess including spaces is a good start, but it would be nice to have the ability to add other characters too. Or, allow some kind of alternative spelling where every character is allowed so that people could actually still type my name using an American keyboard or a Czech one or whatever.<p>[1] As a developer, I got into the habit of calling non-English letters as "special characters" until someone pointed out that these characters are only "special" to people who don't use them.
评论 #5714293 未加载
oblio大约 12 年前
This is a good article about this problem: <a href="http://www.w3.org/International/questions/qa-personal-names" rel="nofollow">http://www.w3.org/International/questions/qa-personal-names</a>
tanglisha大约 12 年前
I have a rather long name, and always get irritated about tiny signature boxes.
评论 #5714020 未加载
评论 #5714360 未加载
jwarren大约 12 年前
This is a very tangible problem, and a very solvable one when the right considerations are applied. Good on you for bringing it up. Personal expression, especially at a level as simple as a name, shouldn't be limited by bad software design. Sadly, many designers (possibly including myself!) have native-English bias, and don't cater wholeheartedly to names and characters which are unusual in the US and UK.<p>Unusually, I do feel the need to disagree with the inference that this is evidence of a gender bias in the tech industry. While our industry clearly has a massive gender bias (towards men, obv) and I feel strongly that it's something that needs to be highlighted frequently, I don't think that false positives are beneficial. I think this is a gender-neutral problem, and I think the gender talk is confusing and distracting to the very real problem of Western-centric design and development.
smackfu大约 12 年前
I think we can all agree that not allowing spaces or dashes in a name field is poor, poor programming.
oddshocks大约 12 年前
Ironically, "Error establishing a database connection"
jack-r-abbit大约 12 年前
I've never heard of someone taking both their given last name and their married last name together as their new last name but without a hyphen. This is a new one for me. Hyphenating is very common. But so is replacing your given middle name with your given last name and taking on your married last name. If I saw "Tarah Wheeler Van Vlack" written somewhere I would have just figured you did that. So technically you full name is "Tarah Marie Wheeler Van Vlack". Interesting.<p>Edit: I also have a female friend who I'd always known as Maggie Smith-Brown[1] and I always just assumed that she started as Maggie Smith and married Mr. Brown. Until I met her husband... Mr. Smith-Brown.<p>[1]not real name
评论 #5714828 未加载
评论 #5715095 未加载
evanb大约 12 年前
Physicist Gerard 't Hooft has a whole page about the apostrophe-t in his name<p><a href="http://www.staff.science.uu.nl/~hooft101/ap.html" rel="nofollow">http://www.staff.science.uu.nl/~hooft101/ap.html</a><p>and provides a lengthy list of manglings and mishandlings.
davidjhamp大约 12 年前
My last name is correct and your DB is down
learc83大约 12 年前
What is the solution to this? Names don't always follow first middle last. What about people who have 7 names? What about people who only have 1? Data needs some kind of structure to be useful.<p>I'm about to start a new project, I'm thinking of two fields "Legal Name" and "What should we call you?", both with special characters allowed.<p>But then you can't search by last name, and I think a lot of our users would be confused if names were in order lexicographically by first name.
评论 #5715055 未加载
greenyoda大约 12 年前
Given how infinitely variable names are, I'm not surprised that programmers have trouble getting them right. But I've also seen problems with validating something as simple as an e-mail address. For example, I wanted to get e-mail updates for a shipment on Fedex.com and discovered that I couldn't enter an address that contained more than one dot after the "@": name@example.com was OK, but name@subdomain.example.com wasn't accepted.
sdfjkl大约 12 年前
<i>&#62; Administrative Contact: Wheeler Van Vlack, Tarah</i><p>I think I know what you mean even with the site being down.
tarahmarie大约 12 年前
<a href="http://ow.ly/i/27W6g" rel="nofollow">http://ow.ly/i/27W6g</a> &#60;--- THIS is my issue. I can't even order a replacement debit card online. I have to go into a bank because Bank Of America can't handle my name. This happened two minutes ago.
tnuc大约 12 年前
The persons name is: Tarah Wheeler Van Vlack<p>Shouldn't the name be: Tarah Wheeler van Vlack ?
评论 #5714601 未加载
评论 #5714471 未加载
评论 #5715346 未加载
zarify大约 12 年前
Related: An Aussie journo who goes by one name, and the problems he has with that.<p><a href="http://stilgherrian.com/category/only-one-name/" rel="nofollow">http://stilgherrian.com/category/only-one-name/</a>
LordIllidan大约 12 年前
Is there any need to ask for First or Last Name? Why aren't we just asking for Full Name? Why complicate things?
评论 #5715835 未加载
tarahmarie大约 12 年前
FINALLY. Got site back up. It's anyone's guess how long it stays there, though.