![Which encoding to choose in MySQL - utf8 or utf8mb4 (utf8mb4_general_ci, utf8mb4_unicode_ci or utf8mb4_0900_ai_ci). How do they differ, how are they decoded and possible errors - Eqsash Which encoding to choose in MySQL - utf8 or utf8mb4 (utf8mb4_general_ci, utf8mb4_unicode_ci or utf8mb4_0900_ai_ci). How do they differ, how are they decoded and possible errors - Eqsash](https://eqsash.com/custom/files/images/articles/kakuyu-kodirovku-vybrat-v-mysql.jpg)
Which encoding to choose in MySQL - utf8 or utf8mb4 (utf8mb4_general_ci, utf8mb4_unicode_ci or utf8mb4_0900_ai_ci). How do they differ, how are they decoded and possible errors - Eqsash
![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
![When checking for correct Unicode, minimum MySQL version is incorrect · Issue #2509 · Cacti/cacti · GitHub When checking for correct Unicode, minimum MySQL version is incorrect · Issue #2509 · Cacti/cacti · GitHub](https://user-images.githubusercontent.com/17589018/54251240-92f2e380-4581-11e9-85c1-820b422939fc.png)
When checking for correct Unicode, minimum MySQL version is incorrect · Issue #2509 · Cacti/cacti · GitHub
![Character set 'utf8mb4' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file - Database Administrators Stack Exchange Character set 'utf8mb4' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file - Database Administrators Stack Exchange](https://i.stack.imgur.com/28Ov6.png)
Character set 'utf8mb4' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file - Database Administrators Stack Exchange
How do I solve the problem of "Server sent charset unknown to the client."? - Support & Bugs - Matomo forums
![character encoding - How to convert an entire MySQL database characterset and collation to UTF-8? - Stack Overflow character encoding - How to convert an entire MySQL database characterset and collation to UTF-8? - Stack Overflow](https://i.stack.imgur.com/kQVUm.png)
character encoding - How to convert an entire MySQL database characterset and collation to UTF-8? - Stack Overflow
![php - Collation issue, Is it possible to downgrade/convert from utf8mb4_unicode_ci to utf8_general_ci? - Stack Overflow php - Collation issue, Is it possible to downgrade/convert from utf8mb4_unicode_ci to utf8_general_ci? - Stack Overflow](https://i.stack.imgur.com/bDN59.gif)
php - Collation issue, Is it possible to downgrade/convert from utf8mb4_unicode_ci to utf8_general_ci? - Stack Overflow
![MOODLE 3.x: Warning: mysql_full_unicode_support The current setup of MySQL or MariaDB is using 'utf8'. This character set does not support four byte characters which include some emoji. MOODLE 3.x: Warning: mysql_full_unicode_support The current setup of MySQL or MariaDB is using 'utf8'. This character set does not support four byte characters which include some emoji.](https://uploads-ssl.webflow.com/623bc20a8d5c4a1ea516549f/6242663cbbd625479a11cbb2_mysql_full_unicode_support.png)
MOODLE 3.x: Warning: mysql_full_unicode_support The current setup of MySQL or MariaDB is using 'utf8'. This character set does not support four byte characters which include some emoji.
![character encoding - How to convert an entire MySQL database characterset and collation to UTF-8? - Stack Overflow character encoding - How to convert an entire MySQL database characterset and collation to UTF-8? - Stack Overflow](https://i.stack.imgur.com/vJTVe.png)