For MySQL, most of the time it is better to not use a real collation at all and just do utf8mb4_bin. This disabled weird features like case insensitivity. You d

For MySQL, most of the time it is better to not use a real collation at all and just do utf8mb4_bin. This disabled weird features like case insensitivity. You do need to make sure you properly encode strings, especially if you are working with combining code points. But it is much simpler and a little more efficient.