Recommended database charset and collation for Drupal 7

Drupal 7.50 introduced multi-byte UTF-8 support. 

The recommended charset is: 

utf8mb4

And the recommended collation is: 

utf8mb4_general_ci

WordPress recommends utf8mb4_unicode_ci. 

Source: https://www.drupal.org/node/2754539. In this thread there are some remarks stating that utf8mb4_unicode_ci is better at sorting than utf8mb4_general_ci. 

Add new comment

Plain text

  • No HTML tags allowed.
  • Web page addresses and email addresses turn into links automatically.
  • Lines and paragraphs break automatically.