gistfile1.txt

mysql> SELECT 'Café' COLLATE utf8mb4_unicode_ci = 'Cafe' COLLATE utf8mb4_unicode_ci AS test1;
+-------+
| test1 |
+-------+
|     1 |
+-------+
1 row in set (0.00 sec)

mysql> SELECT '🍣 ' COLLATE utf8mb4_unicode_ci = '🍺 ' COLLATE utf8mb4_unicode_ci AS test2;
+-------+
| test2 |
+-------+
|     1 |
+-------+
1 row in set (0.00 sec)

mysql> SELECT '🍣 ' COLLATE utf8mb4_unicode_520_ci = '🍺 ' COLLATE utf8mb4_unicode_520_ci AS test3;
+-------+
| test3 |
+-------+
|     0 |
+-------+
1 row in set (0.01 sec)