this post was submitted on 16 Nov 2024
1137 points (99.1% liked)

Programmer Humor

19817 readers
57 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 2 years ago
MODERATORS
Feyter@programming.dev
anzo@programming.dev
BurningTurtle@programming.dev
pylapp@programming.dev
1137
Asking the real questions (jlai.lu)
submitted 1 month ago by ElCanut@jlai.lu to c/programmer_humor@programming.dev
219 comments fedilink hide all child comments
 
you are viewing a single comment's thread
view the rest of the comments
[–] rekabis@lemmy.ca 7 points 1 month ago

I have an apostrophe

Scottish/Irish?

some companies see it as a SQL injection hack and sanitize it.

Which kind of apostrophe?

A straight apostrophe, fine - that can and does get used in valid SQL injection attacks. I would be disgusted at any input form that didn’t sanitize that.

But a curly apostrophe? Nothing should be filtering a curly apostrophe, as it has no function or use within SQL. So if you learn how to bring that up in alt codes (Windows, specifically), Key combos (Mac) or dead keys (Linux), as well as direct Unicode codes for most any Win/Mac/*Nix platform, you should be golden.

Unless the developer of that input form was a complete moron and made extra-tight validation.

Plus, knowing the inputs for a lot of extended UTF-8 characters not found on a normal keyboard is also a wee bit of a typing superpower.