HELP! Illegal mix of collations?!

[globofan]

Every time a user posts a new thread on my forums they get a blank page with the message

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

URL it goes to when post thread is submitted is..
http://myforums.com/forums/newthread.php?do=postthread&f=115
containing the above message ^^




It posts the thread, but as you can imagine i want this fixed! I have done a lot of research and can't workout how to fix it. From what i have researched some sites have told me it means..

"If you see this kind of error, that means there's two different collations in your database. "


Hopefully someone can tell me what to do to fix this?

[Seven Skins]

Answer may be here:
http://www.vbulletin.com/forum/showpost.php?p=1728922&postcount=2

.

[globofan]

Is that telling me to go threw the thousands of tables in vbulletin..and change them all to either "utf8_general_ci" or "utf8_unicode_ci"

???

this will take me a few days..surely theres something easier?

when posting a thread.. what tables in MYSQL are used in that proccess?
(as obviously its one of them causing the problem)

[Seven Skins]

I think there are 158 tables in default vb database.
When posting a post/thread many tables gets updated. e.g thread, posts etc....

.