MySQL returns multiple results for one emoji

Question

I am observing strange MySQL behavior for VARCHAR fields that contain one emulator. The join, database, and column are all utf8mb4 encoding and matching.

There is a table with a name categorieswith fields idand title. There are three lines, with the names 💳, 🍌 and 🎁.

When I run a query looking for a line with the title 💳, I get all the other lines with the same emojis, as if MySQL treated them as the same characters.

The expected behavior should be that only the string with is returned.

Answer 1

utf8mb4_unicode_520_ci; Emoji .

Answer 2

, .

https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-sets.html

, .

latin1.

https://dev.mysql.com/doc/refman/5.7/en/case-sensitivity.html