Illegal mix of collations (latin1_swedish_ci,IMPLICIT)

December 2016

If under PhpMyAdmin you get the following error:

 MySQL: Documentation 
#1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' 

This is due to the addition of collation in MySQL and mostly if the character set for the classification of the database is not the same as then one launched by phpMyAdmin.

To remedy simply go to phpMyAdmin homepaect the same set used by the table (usually latin1_swedish containing accented characters)

Related :

This document entitled « Illegal mix of collations (latin1_swedish_ci,IMPLICIT) » from CCM ( is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.