Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
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)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment