I am receiving a "Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='" error when executing a MySQL query in PHP. The odd thing is that the exact same query works when I run it in a phpMyAdmin window but fails when running in PHP.
The PHP query uses "User-Defined Variables" but Im not sure if that has something to do with this problem or not.
These are the settings from my server running the database:
character set client utf8 (Global value) latin1 character set connection utf8 (Global value) latin1 character set database latin1 character set filesystem binary character set results utf8 (Global value) latin1 character set server latin1 character set system utf8 collation connection utf8_general_ci (Global value) latin1_swedish_ci collation database latin1_swedish_ci collation server latin1_swedish_ci
I have been at this for hours and can't fix this problem. I am really not sure what to do. Do I have to modify the server settings above? My hosting provider moved me to a new server this past week and I believe that has something to do with it but I would like to know what the issue is first.
Any help and solutions would be greatly appreciated.