582

submitted 8 hours ago by ElCanut@jlai.lu to c/programmer_humor@programming.dev

91 comments fedilink hide all child comments

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

[-] trustnoone@lemmy.sdf.org 86 points 4 hours ago

I have an apostrophe and it's super annoying as some companies see it as a SQL injection hack and sanitize it.

So I've received ID with Mc%20dole or they add a space in it. Or I'll get a work email with an apostrophe but I cant use it anywhere because sites have it disabled. And I've missed my flight because I changed my ticket once to add the apostrophe and the system just broke at the gate.

Worse yet many flight companies have "you will not be able to board if your ID doesn't exactly reflect your details" but their form doesn't allow it. Even most forms for card payments don't allow it even though it's the name on my card.

[-] agilob@programming.dev 4 points 10 minutes ago* (last edited 10 minutes ago)

I have an apostrophe and it’s super annoying as some companies see it as a SQL injection hack and sanitize it.

My surname contains a character that's only present in the Polish alphabet. Writing my full name as is broke lots of systems, encoding, printed paperwork and even British naturalisation application from on Home Office website. My surname was part of my username back at uni, and everytime I tried to login on Windows, it would crash underlying LDAP server, logging everyone in the classroom out and forcing ICT to restart the server.

[-] someguy3@lemmy.world 15 points 3 hours ago* (last edited 2 hours ago)

you will not be able to board if your ID doesn't exactly reflect your details"

Do they care about an apostrophe though? I can see any punctuation being a problem.

[-] pmk@lemmy.sdf.org 29 points 2 hours ago

I had to convince people to let me on board a plane because my name contain a swedish letter (å). Their computer system translated it into "aa", which then didn't match my passport.

[-] someguy3@lemmy.world 7 points 2 hours ago* (last edited 2 hours ago)

That one I can actually see, having an extra letter that bdoesn't match. Dropped punctuation or symbols (whatever the flair is called) though personally I wouldn't care.

[-] AdNecrias@lemmy.pt 38 points 4 hours ago

%20 is encoded space if I remember right, so even then they were already incorrect

[-] AlecSadler@sh.itjust.works 7 points 2 hours ago

It sounds like maybe they sanitized the apostrophe to a space and then encoded it

[-] MirthfulAlembic@lemmy.world 22 points 4 hours ago

Always worth posting this classic.

[-] JohnEdwa@sopuli.xyz 10 points 2 hours ago* (last edited 2 hours ago)

There's also the version with examples if you want to know exactly what and why it breaks.

And the git that collects all of these in one place, if you want to really nerd out.

[-] SpatchyIsOnline@lemmy.world 4 points 2 hours ago* (last edited 2 hours ago)

This is going to be bobby tables isn't it?

Edit: It wasn't?!

[-] uranibaba@lemmy.world 9 points 3 hours ago

Also relevant: https://www.wired.com/2015/11/null/

[+] TheOctonaut@mander.xyz -14 points 4 hours ago

... why are you putting an apostrophe in McDole? The O-apostrophe in Irish names is an anglicisation of Ó, eg. Ó Briain becomes O'Brien. Mac Dól would become MacDole/McDole.

[-] hypnotoad__@lemmy.ml 51 points 4 hours ago

Yeah fuck this guy for spelling his name the way it was given to him what an asshole

[-] Affidavit@lemm.ee 15 points 3 hours ago

Probably some bureaucrat decades ago making an incorrect assumption that passed down through generations. Happened to my family. No Irish roots whatsoever, yet somehow we ended up with the annoying form-breaking apostrophe in our 'legal' name just because it begins with the letter 'o'.

"Oscar??? Surely, you're mistaken. I hereby decree your name to be O'Scar!" ~Arsehole circa 1937

[-] SkunkWorkz@lemmy.world 7 points 3 hours ago

Yep also happened to my family. There is a y in my family name, but that’s very uncommon in the Netherlands, my last name is of French origin. So some bureaucrat changed it to a Dutch y which is an ij and there was no time to correct it since my grandparents had to catch the boat to flee the former Dutch colony. Now my last name is constantly pronounced wrong. I’m probably going to change it in the future but in the Netherlands you are not allowed to change your name except for a few exceptions. And applying for a name change cost a lot of money and you won’t get it back if they reject it. So I probably have to get a lawyer to do it.

[-] Affidavit@lemm.ee 2 points 1 hour ago* (last edited 1 hour ago)

Yeah, I've considered a name change myself. Decided not to bother as it would mean every time I need to prove my identity to a government organisation I'd need to provide additional change of name documentation.

Government is hard enough to deal with as it is without adding an extra thing that needs to be assessed.