Collation is not valid for character set


If you get an error like this when saving data (e.g. creating a new user):

COLLATION 'utf8_bin' is not valid for CHARACTER SET 'utf8mb4'

It means you need to fix the collation on your database tables (MySQL/MariaDB). The easiest way is with the mysql_collation.php CLI script:

For example to change all tables back to utf8_bin to match this requirement:

php admin/cli/mysql_collation.php --collation=utf8_bin

Note if you are trying to move to utf8mb4 you need to adjust your database server collation settings accordingly.


Revision #1
Created Wed, Jul 8, 2020 10:36 AM by Moodle Wiki
Updated Wed, Jul 8, 2020 10:48 AM by Moodle Wiki