HOWTO: utf8mb4 conversion

andy.vdg 2018-12-02 20:45:38 UTC #1

Keywords: Moodle - Google Cloud Platform - How to - Other
Description:
Was getting the same warning when upgrading as in this thread: https://community.bitnami.com/t/mysql-full-unicode-support/56418

mysql_full_unicode_support; if this test fails, it indicates a potential problem
The current setup of MySQL or MariaDB is using 'utf8'. This character set does not support four byte characters which include some emoji. Trying to use these characters will result in an error when updating a record, and any information being sent to the database will be lost. Please consider changing your settings to 'utf8mb4'. See the documentation for full details.
Couldn't get the SQL to run successfully and found that this option works just as well from the Moodle documentation:
sudo php /opt/bitnami/apps/moodle/htdocs/admin/cli/mysql_collation.php --collation=utf8mb4_unicode_ci sudo /opt/bitnami/ctlscript.sh restart mysql

PHP and UTF8 Issues warning messages after upgrading to moodle 3.8.3+

Database read error after encoding update from utf8 to uft8mb4

jota 2018-12-03 15:36:38 UTC #2

Hi @andy.vdg,

Thank you for using Bitnami. As Juan mentioned in this post, you need to update the encoding of the database

Some links don't work now, but here you have them

https://docs.bitnami.com/google/apps/moodle/administration/backup-restore-mysql-mariadb/
https://docs.bitnami.com/google/apps/moodle/get-started/connect-mysql/
https://docs.bitnami.com/google/faq/administration/control-services/

Happy to help!

Was my answer helpful? Click on

andy.vdg 2018-12-04 19:58:07 UTC #3

Thanks - wasn't really asking for help... rather stating how I solved it which was a lot easier than in the original post.
Just run:

sudo php /opt/bitnami/apps/moodle/htdocs/admin/cli/mysql_collation.php --collation=utf8mb4_unicode_ci
sudo /opt/bitnami/ctlscript.sh restart mysql

It will do everything for you.

Change MariaDB encoding from uft8 to utf8mb4

How to upgrade moodle in google cloud

jota 2018-12-05 10:35:56 UTC #4

Thanks a lot @andy.vdg,

I marked this message as solution, I'm sure it will help the users who run into that issue

system 2018-12-19 10:36:04 UTC #5

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!