I am sick of this. I live in O’Fallon, MO. In my estimation, about 75% of all web applications are broken. They refuse to accept the apostrophe, forcing me to type “OFallon” or “O Fallon”.
This is ridiculous. I see this constantly. I get messages telling me my city does not match my ZIP code. Or better yet, the page completely CRASHES as just happened when I tried to activate my TurboCad license. Taking out the apostrophe corrected the problem.
The problem goes beyond web apps. People don’t seem to understand how to store quotes and apostrophes in database tables, either. I hardly ever see “O’Fallon” on any bills from various utility companies, on catalog mailing labels, etc. I’m sure there are big ZIP code lookup data files out there with my city name stored incorrectly, and these data files are sold and copied from company-to-company, further spreading incorrect information.
Here’s a tip. Test your applications with “unusual” input data. Don’t just try Jones and Smith. Try names like O’Reilly or O’Fallon, and throw in some hyphens, ampersands, less-than characters, and quotes.