Finding Values Case Insensitively With Emojis

I have a table with varchar value that needs to store text values with emojis: CREATE TABLE `my_table` ( `id` bigint(11) NOT NULL AUTO_INCREMENT, `value` varchar(100) COLLATE u

Solution 1:

Solution is to use MySQL 5.6+ and to use utf8mb4_unicode_520_ci collation which doesn't treat all 4 bytes characters as equal