error when try to upgrade

[dtv100]

Database error in vBulletin 3.7.4:

Invalid SQL:

SELECT prefix.*, prefixpermission.usergroupid AS restriction
FROM prefix AS prefix
LEFT JOIN prefixpermission AS prefixpermission ON (prefix.prefixid = prefixpermission.prefixid)
ORDER BY prefix.displayorder;

MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Saturday, March 7th 2009 @ 05:39:09 AM
Error Date : Saturday, March 7th 2009 @ 05:39:09 AM
Script : http://www.domain.com/forums/install...0a2.php?step=5
Referrer :
IP Address : xxxxxx
Username :
Classname : vB_Database
MySQL Version : 5.1.30

any easy way to fix this ?
before the contact host answer i on a unmanage server.

[vbplusme]

This problem has been solved at least twice here. I think if you search of illegal mix you will find the solution

Here is the link that I know fixed one of them:

https://vborg.vbsupport.ru/showpost....22&postcount=4