mysql add tag
Anonymous 1566
The left string contains U+00AD "SOFT HYPHEN", while the right string does not.


Why is the result "1" (true) on MySQL 8.0? What change was being introduced?

Top Answer
Jack Douglas
The default character set [changed in version 8.0.1](

> …the default character set has changed from latin1 to utf8mb4.

MySQL compares two strings in a 'lazy' fashion, so for example the compare is [case insensitive by default]( The details vary by collation.

If you want to compare strings more precisely, you can do a binary compare, or chose a different collation:


This room is for discussion about this question.

Once logged in you can direct comments to any contributor here.

Enter question or answer id or url (and optionally further answer ids/urls from the same question) from

Separate each id/url with a space. No need to list your own answers; they will be imported automatically.