this post was submitted on 16 Nov 2024
639 points (99.4% liked)

Programmer Humor

19564 readers
1311 users here now

Welcome to Programmer Humor!

This is a place where you can post jokes, memes, humor, etc. related to programming!

For sharing awful code theres also Programming Horror.

Rules

founded 1 year ago
MODERATORS
 
you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 97 points 6 hours ago (5 children)

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.

[–] [email protected] 11 points 1 hour ago* (last edited 46 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 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.

[–] [email protected] 17 points 4 hours ago* (last edited 1 hour ago) (1 children)

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 for systems.

[–] [email protected] 35 points 4 hours ago (2 children)

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.

[–] [email protected] 1 points 21 minutes ago

Your name is transliterated in your passport? That's on the Swedish authorities then.

[–] [email protected] 8 points 3 hours ago* (last edited 1 hour ago) (1 children)

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

[–] [email protected] 3 points 56 minutes ago (1 children)

That's the wrong way of looking at an å.

It's not just an a with decoration. It actually has different pronunciation and is typically replaced with aa if no å is available. (I'm neither Swedish nor Norwegian, so not 100% sure, but it's what happened to Erling Haaland).

Similarly, you would replace a German ä with ae. So if my name was Bäcker, it would be wrong to spell it Backer on a ticket. Baecker would be the way.

[–] [email protected] 1 points 46 minutes ago* (last edited 44 minutes ago)

Yes I'm aware it's not an a with decoration jfc. I'm saying for computer entries that garble things, I wouldn't care about matching it up so perfectly (with dropped whatever those things are called) as to not allow someone to board a plane.

[–] [email protected] 43 points 6 hours ago (1 children)

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

[–] [email protected] 13 points 3 hours ago

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

[–] [email protected] 26 points 5 hours ago (3 children)
[–] [email protected] 12 points 3 hours ago* (last edited 3 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.

[–] [email protected] 5 points 3 hours ago* (last edited 3 hours ago)

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

Edit: It wasn't?!