Log in

View Full Version : Illegal mix of collations


fredang85
08-12-2008, 07:38 AM
Hi, all, I am having this problem when I use the automatic thread tagging script.

I receive this problem halfway through which means that it isn't the script problem, but more of an mySQL problem which the coder could not help me with.

So does anyone knows how to solve this?

Invalid SQL:

SELECT tagid
FROM vBull_tag
WHERE tagtext IN ('russian', 'Вообщем', 'привет', 'всем');

MySQL Error : Illegal mix of collations for operation ' IN '

Marco van Herwaarden
08-12-2008, 07:40 AM
You should ask this in ths thread of the tagging modification script you are using. Most likely it has created tables with a different chracterset/collation.