Database Error

How can I fix this error:

Database error in vBulletin 3.6.7:

Invalid SQL:

SELECT t.champion, u.userid FROM vb_tournaments AS t
LEFT JOIN vb_user AS u ON (t.champion = u.username)
WHERE champion<>'';

MySQL Error : Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
Date : Saturday, May 19th 2007 @ 07:39:21 AM
Script : http://www.computerforumz.org/showthread.php?p=14170
Referrer : http://www.computerforumz.org/index.php
IP Address : 172.159.225.161
Username : giovanni
Classname : vb_database

[erdiyilmaz]

Originally Posted by MortysTW

Was this the solution?

no no, he said that, i had to search @ googLe, search for "illegal mix"

: (

[MortysTW]

Originally Posted by erdiyilmaz

no no, he said that, i had to search @ googLe, search for "illegal mix"

: (

Since you can understand english, have you tried switching everything to ENGLISH mode to see what happens?

That might help with troubleshooting if you can close up a few loose ends of this strange issue.