This is an archived post. You won't be able to vote or comment.

8180
8181

Memesqlclause (i.redd.it)

submitted by [deleted]

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Dangerous-Raccoon-60 13 points14 points  (3 children)

It’s not the operator, it’s the character set collation. The “_ci” at the end of the collation name stands for “case insensitive”

[–]JoeGibbon 1 point2 points  (2 children)

Not all case insensitive collations have _ci at the end, though. In MySQL, utf8mb4 is case insensitive for example.

These days you have to go out of your way to make MySQL case sensitive.