Drupion switches to multi-byte UTF-8 supported MariaDB database

Since Drupal 7.50 introduced multi-byte UTF-8 support for MySQL and other database drivers, allowing for emojis, Asian symbols, mathematical symbols, etc., it has been possible to get such symbols to be properly stored by and displayed on Drupal 7 sites.

However, the 4 byte UTF-8 support on most Drupal 7 websites remain still disabled because of mainly two reasons:

1. The hosting providers keep deploying their database servers with such traditional collation types as, for example, 'latin1_swedish_ci' and require their customers to manually change the collation for their applications;

2. Even with the right collation set on the server-side and the detailed instructions provided on https://www.drupal.org/node/2754539 most users find it quite difficult to configure their websites to properly support this new feature.

So to address this issue, as of today January 20, 2017 we have started to deploy our new servers with the latest official MariaDB version configured with the 'utf8mb4' for character set and the 'utf8mb4_unicode_ci' for collation by default.

Moreover, the latest DrupionOS control panel allows creating Drupal websites with all the necessary changes performed automatically, so you don't have to do anything manually on Drupal-side or on a command line. All that you need is to use one-click Drupal setup feature and then to enjoy the status page of your website in all green colors.

Existing Drupion customers may file requests for the multi-byte UTF-8 support through Drupion Dashboard and we will gladly upgrade your server with the new features.

Add new comment