Illegal mix of collations (latin1_swedish_ci,IMPLICIT)

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)

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
This document, titled « Illegal mix of collations (latin1_swedish_ci,IMPLICIT) », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (