Investigate Mysql2::Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) · Issue #1800 · ualbertalib/discovery · GitHub
![After migration to MySql 8 from 5.7 - Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '=' - Stack Overflow After migration to MySql 8 from 5.7 - Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '=' - Stack Overflow](https://i.stack.imgur.com/HMjaM.png)
After migration to MySql 8 from 5.7 - Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '=' - Stack Overflow
![mysql - Illegal mix of collations (utf8mb4_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation '=' - Stack Overflow mysql - Illegal mix of collations (utf8mb4_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation '=' - Stack Overflow](https://i.stack.imgur.com/eA5TQ.png)
mysql - Illegal mix of collations (utf8mb4_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation '=' - Stack Overflow
![Illegal mix of collations (utf8mb4_unicode_ci,EXPLICIT) and (utf8_general_ci,COERCIBLE) for operation '<' - Metabase Discussion Illegal mix of collations (utf8mb4_unicode_ci,EXPLICIT) and (utf8_general_ci,COERCIBLE) for operation '<' - Metabase Discussion](https://discourse.metabase.com/uploads/default/original/2X/4/4af0aa5398fe44437e0e57982dd8b05ae2d63e59.png)
Illegal mix of collations (utf8mb4_unicode_ci,EXPLICIT) and (utf8_general_ci,COERCIBLE) for operation '<' - Metabase Discussion
![Another "Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='" - Using my Dolibarr - Dolibarr international forum Another "Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='" - Using my Dolibarr - Dolibarr international forum](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/f/f7d2a0ec688f0e537f1172bee15a4c3bfd7ab473.png)
Another "Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='" - Using my Dolibarr - Dolibarr international forum
![mysql - How to fix "Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='" - Stack Overflow mysql - How to fix "Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='" - Stack Overflow](https://i.stack.imgur.com/RvZql.png)
mysql - How to fix "Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='" - Stack Overflow
Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' · Issue #24522 · Dolibarr/dolibarr · GitHub
![Illegal mix of collations (utf8mb4_unicode_ci,EXPLICIT) and (utf8_general_ci,COERCIBLE) for operation '<' - Metabase Discussion Illegal mix of collations (utf8mb4_unicode_ci,EXPLICIT) and (utf8_general_ci,COERCIBLE) for operation '<' - Metabase Discussion](https://discourse.metabase.com/uploads/default/original/2X/4/4dff5cb03b088bb0c35425ce8ef626baf9a9f270.png)
Illegal mix of collations (utf8mb4_unicode_ci,EXPLICIT) and (utf8_general_ci,COERCIBLE) for operation '<' - Metabase Discussion
How to fix the MySQL error: Illegal mix of collations for operation union - Massimo Caliman - Medium
![MySQL Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'Concat' – candokendo MySQL Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'Concat' – candokendo](https://askimran.files.wordpress.com/2016/05/collations.png)