Odhiambo,
Have you tried changing the collation of the affected tables?�� MySQL has some odd default collations, I have changed a lot of mine to just plain UTF8_bin across the board, and try to remember to do this whenever I set up a new database.�� However, I have not had issues with changing the collation after the fact, but your mileage may vary.

A couple articles on the subject:

fixing mysql collation error

stackoverflow thread

regardless, you might want to set up a separate database for testing and import your data there before trying it on your live data.�� of course make a backup of the database before you start anything, not sure if you can quiesce your service while you work on this but that would help prevent new entries into the database.

Hope this helps you some.�� Personally I have not run into this error myself (that I know of!), but the default mysql collations have always bugged me.

Helmut

On 3/26/2019 1:32 AM, Odhiambo Washington wrote:

I am using MySQL-8.x

I realized that some lookups on the blocklists table were stopping mails from being delivered.

MYSQL: query failed: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,COERCIBLE) for operation '='

So I had to comment out all blocklists lookups (my people don't even create custom ones though) pending advise from here.

Anyone dealt with this issue before, or it's only me on MySQL-8.x??

TIA

--

Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.",��grep ^[^#] :-)
_______________________________________________
users mailing list
users@exim4u.org
https://exim4u.org/mailman/listinfo/users