Programmer Humor

19817 readers

216 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

Keep content in english
No advertisements
Posts must be related to programming or programmer topics

founded 2 years ago

MODERATORS

[email protected]

-13

What "make america great again" hats should say instead (sql injection) (lemmy.ca)

submitted 5 days ago by [email protected] to c/[email protected]

10 comments fedilink hide all child comments

'; UPDATE countries SET great = true WHERE name = 'America'; --

More based: '; UPDATE countries SET great = true; --

(this is not an endorsement of donald trump)

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

[–] [email protected] 5 points 5 days ago (3 children)

Ahem pushes glasses up nose arch, umm ackshually you would need to use ILIKE if you're feeding in America in all caps unless you have a custom caseless collation set on that column.

[–] [email protected] 4 points 5 days ago (2 children)

I haven't used a database that required me to specify case in 15 years, and I'll be cold dead in the grave before I do it again... only because I assume that's what they use IN HELL.

[–] [email protected] 4 points 5 days ago (1 children)

All string comparisons are case insensitive by default? Is that an Oracle thing?

Postgres absolutely supports case based string diffentiation in data (by default all DB identifiers are case insensitive though which I absolutely appreciate).

[–] nogooduser 1 points 4 days ago

Microsoft SQL Server is most commonly set up as case insensitive in my (limited) experience (it does support case sensitivity too).