So, I take it the UK now needs to rename Land's End and John o' Groats.
North Yorkshire Council to phase out apostrophe use on street signs
11–20 of 233 posts
Re: North Yorkshire Council to phase out apostrophe use on street signs
#12The best part of this article is: Ruby Wang... did not mind the changes. "To be honest with you, because I'm not from this country it doesn't matter because it's the same pronunciation," she added.
And then the photo of her looks exactly like my wife when she doesn’t give a shit about my bullshit
Re: North Yorkshire Council to phase out apostrophe use on street signs
#13I can't find a public copy of the recent versions of BS7666. The 2006 version had zero instances of the word 'apostrophe' so not sure what they think they are referencing. BS 7666: 2006 is based upon an International Standard ISO 19112 Spatial referencing by geographic identifiers.
“The AGI now has a membership portal and it may be that the page you require sits within that portal. As a member you will be able to reach the page by logging in. If you are not yet a member of the AGI and are interested in joining please visit”
If a standard isn’t publicly available under a free license it should not be called a standard.
Re: North Yorkshire Council to phase out apostrophe use on street signs
#14Makes 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!
Re: North Yorkshire Council to phase out apostrophe use on street signs
#15As 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 ’
Re: North Yorkshire Council to phase out apostrophe use on street signs
#16So, I take it the UK now needs to rename Land's End and John o' Groats.
Not to mention Westward Ho!.
Re: North Yorkshire Council to phase out apostrophe use on street signs
#17I don't really understand why they've decided to do this in 2024.
We all know that older systems had problems with encoding and escaping special characters, but wouldn't they have encountered and dealt with all the possible problems by now?
Re: North Yorkshire Council to phase out apostrophe use on street signs
#18As 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
H2 offers quite a comprehensive solution for dealing with this:
> [H2] provides a way to enforce usage of parameters when passing user input to the database. This is done by disabling embedded literals in SQL statements. To do this, execute the statement:
> SET ALLOW_LITERALS NONE;
> Literals can only be enabled or disabled by an administrator
Re: North Yorkshire Council to phase out apostrophe use on street signs
#19As 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 ’
The Hawaiʻian ʻokina symbol begs to differ...