[Server Config] what database should i use for support Emoji

[Raykai]

Hi, my forum will use English and French languages.
what I would like to know is what kind of database I need to support Emoji?

I know that I need UTF8MB4 but there are many kinds like utf8mb4_bin, utf8mb4_general_ci, utf8mb4_unicode_ci, utf8mb4_unicode_520_ci and so on and i don't know which to choose from.

I'm using Plesk panel if this can help... i don't know much about MySQL. by default, it looks like my Plesk creates a database as utf8_general_ci.

[Wayne Luke]

Each of the variants is how MySQL/MariaDB will sort query results.

• This sort order is represented by a keyword like general, unicode, swedish, german, etc... general and unicode are more generic.
• Numbers like 520 and 900 are the version of Unicode supported. I believe 900 is the newest.
• ai means Accent Insensitive. So these characters e, è, é, ê, and ë are all treated as equal as far as sorting is concerned.
• ci means Case Insensitive. So E and e are treated the same for sorting.

If you don't know of specific requirements for your specific language, then you should use utf8mb4_general_ci or utf8mb4_unicode_ci. If you're not using English, then unicode will provide better sorting for multiple languages.