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