I'm working on a backend that needs to store universal characters.
I've chosen utf8mb4
Table Encoding for that purpose. I also have to choose Table Collation.
The most straightforward option is to choose utf8mb4_general_ci
Table collation. Besides the general one, there is also about 20 others collations to choose from.. What is the purpose of the more specific ones? Does utf8mb4_general_ci
or maybe utf8mb4_unicode520_ci
cover all of them? Which one should I use if I want to store characters ranging from chinese all the way to arab.