gistfile1.txt

mysql56> SELECT HEX(sushi), HEX(beer), sushi = beer FROM t1;
+------------+-----------+--------------+
| HEX(sushi) | HEX(beer) | sushi = beer |
+------------+-----------+--------------+
| F09F8DA3   | F09F8DBA  |            1 |
+------------+-----------+--------------+
1 row in set (0.00 sec)

mysql56> SELECT HEX(sushi), HEX(beer), sushi COLLATE utf8mb4_bin = beer COLLATE utf8mb4_bin FROM t1;
+------------+-----------+------------------------------------------------------+
| HEX(sushi) | HEX(beer) | sushi COLLATE utf8mb4_bin = beer COLLATE utf8mb4_bin |
+------------+-----------+------------------------------------------------------+
| F09F8DA3   | F09F8DBA  |                                                    0 |
+------------+-----------+------------------------------------------------------+
1 row in set (0.00 sec)

mysql56>
mysql56> SELECT HEX(sushi), HEX(beer), sushi COLLATE utf8mb4_general_ci = beer COLLATE utf8mb4_general_ci FROM t1;
+------------+-----------+--------------------------------------------------------------------+
| HEX(sushi) | HEX(beer) | sushi COLLATE utf8mb4_general_ci = beer COLLATE utf8mb4_general_ci |
+------------+-----------+--------------------------------------------------------------------+
| F09F8DA3   | F09F8DBA  |                                                                  1 |
+------------+-----------+--------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql56> SELECT HEX(sushi), HEX(beer), sushi COLLATE utf8mb4_unicode_ci = beer COLLATE utf8mb4_unicode_ci FROM t1;
+------------+-----------+--------------------------------------------------------------------+
| HEX(sushi) | HEX(beer) | sushi COLLATE utf8mb4_unicode_ci = beer COLLATE utf8mb4_unicode_ci |
+------------+-----------+--------------------------------------------------------------------+
| F09F8DA3   | F09F8DBA  |                                                                  1 |
+------------+-----------+--------------------------------------------------------------------+
1 row in set (0.00 sec)