Robert '); DROP TABLE Students;-- ? would be proud that this village in England cannot sanitize their freaking inputs by substituting an accent acute for apostrophe in the names. (Or be able to use unicode extended codepage identical appearing characters with a different value, like U-2019, instead.)
Nope. Too much work. Cant have the office drones actually have to learn how to sanitize things, now can we? /snark
Eh, sure ... in an ideal world every piece of software and every data entry person in every office would do everything perfectly.
In the real world, where everything costs money, systems are diverse, and chaos is real ... it might very well be simpler to just train people not to use punctuation in names. (And to just strip it from inputs rather than use possibly disparate encoding methods.)