By sprite on

What character collation are you using in your Drupal database?

What in your opinion are the benefits of using the various available collations?

- utf8mb4_general_ci

versus

- utf8_general_ci

If so, are you translating your website(s) into multiple languages?

Comments

Jaypan’s picture

Jaypan commented

Until recently, the default has been utf8_general_ci. However, this had limitations in that it could not save the code behind emojis, so if someone posted an emoji to a Drupal site, it would not save it correctly. As of Drupal 7.50 (not sure about the D8 version), Drupal recommends switching to utf8mb4_general_ci, which will save emoji code.

It doesn't have anything to do with multilingual sites (though they will be supported). If you will never need emojis on your site, you can stay with utf8_general_ci.

sprite’s picture

sprite commented

Thank you for your thoughts and insights.

spritefully yours
Technical assistance provided to the Drupal community on my own time ...
Thank yous appreciated ...