Enabling MySQL 4-byte support¶
Note
This feature is currently experimental.
In order to use Emojis on your Nextcloud server with a MySQL database, the installation needs to be tweaked a bit.
Update your Nextcloud server to Nextcloud 11 or later.
Make sure the following InnoDB settings are set on your MySQL server:
[mysqld] innodb_large_prefix=true innodb_file_format=barracuda innodb_file_per_table=true
Restart the MySQL server in case you changed the configuration in step 2.
Change your databases character set and collation:
ALTER DATABASE nextcloud CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
Set the
mysql.utf8mb4
config to true in your config.php:$ sudo -u www-data occ config:system:set mysql.utf8mb4 --type boolean --value="true"
Convert all existing tables to the new collation by running the repair step:
$ sudo -u www-data occ maintenance:repair
Now you should be able to use emojis like 🎉
in your file names, calendar events, comments and many more.