- Forums
- PHP
- I get the error 'Illegal mix of collations', what should I do?
This Page Contains information about I get the error 'Illegal mix of collations', what should I do? By bigger_travis in category PHP with 0 Replies. [970], Last Updated: Sat May 18, 2024
bigger_travis
Mon Nov 06, 2006
0 Comments
792 Visits
If you get the error
CODE:
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)
then you are probably using a buggy MySQL version. MySQL 4.1.16 and later as well as 5.0.17 and later have this bug fixed. Please see:
http://bugs.mysql.com/bug.php?id=10446. If you get this error during upgrade from G2.0.x or older to G2.1 or newer, please see: MySQL Upgrade Issue - UTF-8.