Database collation should be utf8mb4_unicode_ci #323

Describe the bug

The MoodleBox database collation is utf8mb4_general_ci and should be utf8mb4_unicode_ci instead.
Please look at https://docs.moodle.org/403/en/MySQL_full_unicode_support

To Reproduce

You can see the database collations when you get http://moodlebox.home/adminer.php
And you should see the database collation in the Moodle config.php

Expected behavior

I think your setting with the collation utf8mb4_general_ci should be no problem as long as nobody gets a collation mix in the database. I heart about the mix problem in https://moodle.org/mod/forum/discuss.php?d=455362 . I can’t say if the installation of a plugin will be able to add database tables with a different collation.

Additional context

• Raspberry Pi 4B
• MoodleBox 4.6.0
• MoodleBox plugin 2.17.4
• Moodle 4.3.3+ (20240215)

Screenshots

No screenshot