Which of utf8 collations is the best?
Yes, that is correct. UTF-8 is an encoding for the Unicode character set, which supports pretty much every language in the world.
I think the only difference comes with sorting your results, different letters might come in a different order in other languages (accents, umlauts, etc.). Also, comparing a
to ä
might behave differently in another collation.
The _ci
suffix means sorting and comparison happens case insensitive.
http://www.collation-charts.org/ might be of interest to you.
As UTF8_GENERAL_CI
was a good decision some time ago. It has some drawbacks now.
MySQL's UTF8 actually uses 3 bytes instead of 4, which you need for symbols like emojis and new asian chars.
So MySQL has a newer charset called utf8mb4 which actually complies with UTF8 definition.
To be able fully support Asian languages you will need to choose utf8mb4.
If you care about correct sorting in multiple languages, use utf8mb4_unicode
or utf8mb4_unicode_ci
instead general.
A more detailed answer you can find in What's the difference between utf8_general_ci and utf8_unicode_ci