Illegal Mix of Collations

If you receive an error like this:

Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) 
for operation '='
INSERT INTO mdl_scorm_scoes_value (attemptid, scoid, elementid, value, timemodified)

It is indicating that you have tables with different collation types in your database e.g. utf8_unicode_ci vs utf8_general_ci

You'll need to change them all to the same type using the mysql_collation.php CLI tool:

e.g. change them all to utf8_unicode_ci.

php admin/cli/mysql_collation.php --collation=utf8_unicode_ci
Converted: 168, skipped: 1663, errors: 0
No Comments
Back to top