No announcement yet.

what database should i use for support Emoji

  • Filter
  • Time
  • Show
Clear All
new posts

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

    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.

  • #2
    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.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API


    Related Topics