TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

North Yorkshire to phase out apostrophes on street signs, citing database issues

4 pointsby cowsupabout 1 year ago

3 comments

beardywabout 1 year ago
Scenario:<p>&quot;When we do db lookups it&#x27;s easier if there is no punctuation.&quot;<p>&quot;OK, easy, let&#x27;s take out the punctuation&quot;<p>Later:<p>&quot;It turns out that data is used to make Street signs&quot;<p>&quot;Well, it&#x27;s sort of a problem with the database isn&#x27;t it ....&quot;
cranberryturkeyabout 1 year ago
so instead of properly escaping their sql queries they chose to remove the offending character from the street signs??
bell-cotabout 1 year ago
Obligatory XKCD reference:<p><a href="https:&#x2F;&#x2F;xkcd.com&#x2F;327&#x2F;" rel="nofollow">https:&#x2F;&#x2F;xkcd.com&#x2F;327&#x2F;</a>