Database/SQL errors ⇒ Frequently Asked Questions ⇒ CPG Dragonfly™ CMS
Illegal mix of collations
This happens in MySQL 4.1/5.x when the Dragonfly database connection is set to utf8 but your tables are in a different collation, for example latin1_general_ci instead of the needed utf8_general_ci.
To fix this problem you may do one of the following things:
1. Fix the database table and column collations
Ofcourse you may choose any other collation if your website is specialy aimed at the Swedish language for example. then you may choose utf8_swedish_ci as collation.