Mysql error: Illegal mix of collations

Hello

I'm getting this Databse error today can you tell me wat is the problem and how to get fix

Thank's

Database error in

Query:

SELECT DISTINCT tmpl.`ID` AS `id`, tmpl.`Name` AS `name`, tmpl.`Subject` AS `subject`, tmpl.`Body` AS `body`, tmpl.`Desc` AS `description` FROM `sys_email_templates` tmpl, `modzzz_notify_main` mn WHERE mn.`template` =tmpl.`Name`  AND `LangID`='0' ORDER BY `ID`

Mysql error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='

Illegal mix of collations is the issue.

And doing a quick search shows that you (ufo360) have all ready been showen how to fix the issue (by deno).

http://www.boonex.com/unity/forums/?action=goto&topic_id=Database-error-in--2010-06-23

I have also helped someone else with a similar issue here: http://www.boonex.com/unity/forums/?action=goto&topic_id=World-Maps

And there are a lot of other posts that address this issue.

Thank's

I will give a try man

I check all my system tables

and the only one wrong is the system_email_templates I change from  utf8_unicode_ci  to  utf8_general_ci

but still the same error I clean my caches and nothing still the same