Interesting way to tell the world you're vulnerable to SQL injection
Yorkshire
General Instance Rules:
- No racism, sexism, homophobia, transphobia or xenophobia.
- No incitement of violence or promotion of violent ideologies.
- No harassment, dogpiling or doxxing of other users.
- Do not share intentionally false or misleading information.
- Do not spam or abuse network features.
Community Specific Rules:
- Keep comments in English so that they can be appropriately moderated.
Related Communities:
“This restricts the use of punctuation marks and special characters (eg apostrophes, hyphens and ampersands) to avoid potential problems when searching the databases as these characters have specific meanings in computer systems.”
That sounds more like a pretty basic database design issue.
The database language is what it is. The application should be forming a well structured query to the database. Working around issues like this has been well established for a long time now. I'm guessing they have some bad software and for whatever reason they're not addressing it correctly.
Some residents expressed reservations about removing the apostrophes, and said it risked “everything going downhill”.
They should be careful, some of those people sound pretty miffed. There could be muttering and grumbling going on.
Simply awful state of affair’s.