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.

No Comments
Back to top