- ericjmorey ( @ericjmorey@programming.dev ) 23•2 months ago
"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.
- Lmaydev ( @Lmaydev@programming.dev ) 8•2 months ago
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.
- colournoun ( @colournoun@beehaw.org ) 16•2 months ago
Ah, yes, I live on “St Mary’ ; DROP TABLE street”
- lad ( @sukhmel@programming.dev ) 10•2 months ago
“we call it Drop street for short”
- lad ( @sukhmel@programming.dev ) 4•2 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
- porgamrer ( @porgamrer@programming.dev ) 17•2 months ago
How did they ask all these random people and not bother to ask a single software engineer?
“Hi is this excuse real, or is it just a sign of an inappropriate relationship between the local council and a dodgy software company that pays more dividends than developers? Oh it’s the latter? Okay, thanks.”
- floofloof ( @floofloof@lemmy.ca ) English14•2 months ago
So North Yorkshire Council just announced to the whole world that its systems are vulnerable to SQL injection and it’s easier to replace the signs than to fix the software?
- onlinepersona ( @onlinepersona@programming.dev ) English7•2 months ago
Probably interpolated strings are used in their DB queries. But instead of fixing the code, it’s probably cheaper to fix the road-signs. Seems to me like they need to overhaul their IT system.
- Blackmist ( @Blackmist@feddit.uk ) English7•2 months ago
Time to upgrade their systems to support UTF8.
Can’t wait to live on 💩 🕳️ 🛣️.
- Sizzler ( @Sizzler@slrpnk.net ) 4•2 months ago
Half the yoofs in yorks, “picks up a screwdriver, whistling. " Off to grab some limited edition street signs lads”"
- NigelFrobisher ( @NigelFrobisher@aussie.zone ) 3•2 months ago
Good luck writing Yorkshire dialect without t ‘umble apostrophe, dick’eads
- AnarchistArtificer ( @AnarchistArtificer@slrpnk.net ) English2•2 months ago
One of my favourite Yorkshire dialect jokes is how “tin tin tin” can mean the complete sentence “It isn’t in the tin”