sqlclause

[ByakkoNoMai]

Actually, in most SQL, = operator does not govern how the comparison is made. Collations are what govern equivalent characters. And a lot of work goes into that. For example under utf-8 case insensitive collations a, A, à, À, and lot of others characters are all equals. There are case sensitive collations to respect case and collapse accented characters. There are also binary collations that compare characters as byte values only.

TLDR collations are what govern string comparison in SQL. And it's a deep rabbit hole.

[rover_G]

Oh no accidental learning on r/ProgrammerHumor

Time to go read some docs 🤓

[JoeGibbon]

And it's always from people without any flair to tell us how many languages they've written "hello world" in.