Programming

17416 readers

37 users here now

Welcome to the main community in programming.dev! Feel free to post anything relating to programming here!

Cross posting is strongly encouraged in the instance. If you feel your post or another person's post makes sense in another community cross post into it.

Hope you enjoy the instance!

Rules

Follow the programming.dev instance rules
Keep content related to programming in some way
If you're posting long videos try to add in some form of tldr for those who don't want to watch videos

Wormhole

Follow the wormhole through a path of communities [email protected]

founded 1 year ago

MODERATORS

[email protected]

North Yorkshire Council to phase out apostrophe use on street signs (www.bbc.com)

submitted 6 months ago by [email protected] to c/[email protected]

21 comments fedilink hide all child comments

you are viewing a single comment's thread
view the rest of the comments

[–] [email protected] 38 points 6 months ago* (last edited 6 months ago) (2 children)

"All punctuation will be considered but avoided where possible because street names and addresses, when stored in databases, must meet the standards set out in BS7666.

"This restricts the use of punctuation marks and special characters (e.g. apostrophes, hyphens and ampersands) to avoid potential problems when searching the databases as these characters have specific meanings in computer systems."

This seems like a dumb line of reasoning. The problem has never been the signs or punctuation in a database. It's that the people in charge don't even know what BS7666 even says.

[–] [email protected] 8 points 6 months ago (1 children)

We have a piece of legacy software and we have to replace certain symbols in text values as there's manual SQL construction everywhere and none of it uses parameters.

[–] [email protected] 16 points 6 months ago (1 children)

Ah, yes, I live on “St Mary’ ; DROP TABLE street”

[–] [email protected] 10 points 6 months ago

"we call it Drop street for short"

[–] [email protected] 4 points 6 months ago

I thought it's the standard's name that fits the situation, but it appears to be humans at a blame as usual