Mixed Collation Errors

How to handle “Illegal mix of collations” after upgrade

If you are getting PHP log files that say things like:

Illegal mix of collations (latin1_general_cs,IMPLICIT) and (latin1_general_ci,IMPLICIT) 


Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) 

the easiest way to fix this is to simply convert your database to use UTF8. Fortunately there is a UTF8 Conversion Tool you can run to do this.

Still have questions? Use the Search box in the upper right, or try the full list of FAQs. If you can't find it there, head over to the Zen Cart support forum and ask there in the appropriate subforum. In your post, please include your Zen Cart and PHP versions, and a link to your site.

Is there an error or omission on this page? Please post to General Questions on the support forum. Or, if you'd like to open a pull request, just review the guidelines and get started. You can even PR right here.
Last modified March 30, 2024 by Scott Wilson (cb23393).