"News" app expects utf8_mb4 - What should I do?

🍱 Features & apps
1

Running NextCloud on a CentOs 6 VPS.

After installing the News app, and enabling the Server Cron, I get the notice that the database does not have the right encoding.

I installed NextCloud 15 via Softaculous.

Database is MySQL with latin charset, all tables and fields do have utf8_bin encoding.

What should I do? Change everything to utf8_mb4?

I guess the News app wants this because of all the fancy emoticons.

Why does NextCloud installation not enable the utf8_mb4 by default, being it the true utf8 encoding?

NextCloud is amazing, by the way.

2

Hey,

same issue here on Raspberry pi3 NC15.0.2 with MySQL/MariaDB.

3

Did it and now its fine, no negative or strange things after the change

4

When I try to, MySQL prompts:

ALTER TABLE `oc_addressbooks` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

Key declaration is too long.

If I ignore the collation in that table, the News app keeps showing the notification.

It’s not a big deal, just wondering.