31–40 of 233 posts
As if database were not able to del with apostrophes or other special characters... Yes you have to sanitize your queries, but you have to do it anyway. Client applications will of course have to be smarter
I think part of the problem with apostrophes is also that there's two characters for it. ' and ’
I guess there are lots more in other languages...
I have a street in a town near me which grammatically should be called St. Thomas' road. However, the street signs call it St. Thomas road at the north end and St. Thomas's road at the south end.
So, no "O'Malley" or "O'Kelly" or "O'Brien" will ever be honored with a street name in North Yorkshire using their actual (Anglicized) name? This isn't a new issue. Around 1990 one of the computer labs at my school was run by someone with an Irish surname starting "O'", and I remember him complaining about software which couldn't handle his name. It's been 30 years, and there are still problems?!? (To say nothing of…
https://members.parliament.uk/members/commons?SearchText=%27...
However, it does seem like it could be helpful when it comes to satnav applications to remove ambiguity. Google's going to autocorrect most of the time anyway, but this way, you're less likely to run into an issue where it takes you to Kings Landing in the wrong town because you didn't type King's Landing in the town you meant.
Sure, they tell you what town you're looking at, but I can't be the only one who's quickly typed in a destination and didn't take the time to double check and ended up driving to the wrong location for something. For some reason all of the hockey rinks near me have almost identical names...
I live on Bobby Tables Close.
Makes sense IMO, the apostrophes don't add much but can cause a lot of issues in manual transcription, simple queries, etc.
As always, the problem is always the underlying issue, even though the surface one is pretty ridiculous. If the council doesn't understand how to sanitise database input, imagine just how bad they are at the stuff that's mildly difficult or worse. Do NOT give any sensitive data to them, whatever you do!
Searching if users omit the apostrophes, etc.
I have a street in a town near me which grammatically should be called St. Thomas' road. However, the street signs call it St. Thomas road at the north end and St. Thomas's road at the south end.
Thomas' is not grammatically correct in any version of English that I know. It's not plural. There is no special rule for that. Both the street signs you mentioned are at least grammatically coherent
Thomas’ and Thomas’s are the same thing.
(If all you have is a phone, everything can be solved with an app.)
Earlier quoted context omitted.
Thomas' is not grammatically correct in any version of English that I know. It's not plural. There is no special rule for that. Both the street signs you mentioned are at least grammatically coherent
When a word ends with an s, the use of an apostrophe without another s is valid English. Thomas’ and Thomas’s are the same thing.