4 ms·
==do not follow this article== It uses the old/previous MySQL utf8mb4 default collation, `utf8mb4_unicode_ci`; from MySQL 8.0 GA onwards, the new default is `u
by pizza234 6y ago
==do not follow this article==
It uses the old/previous MySQL utf8mb4 default collation, `utf8mb4_unicode_ci`; from MySQL 8.0 GA onwards, the new default is `utf8mb4_0900_ai_ci`.
Migrating between the two can't be done easily for an entire DB (migrating from utf8 is easy, instead), so those who happened to use the former collation by accident, and later decide to switch, are going have... interesting times.
- acomjean 6y agoas someone who's using old mysql (I can only use utf8), and we're getting our database upgraded, do you have any reference documentation for this? (is the type still utf8mb4 and only the collation is different?) I wish character encoding was settled..
- pizza234 6y agoThis is a thorough guide: https://saveriomiroddi.github.io/An-in-depth-dbas-guide-to-migrating-a-mysql-database-from-the-utf8-to-the-utf8mb4-charset https://saveriomiroddi.github.io/An-in-depth-dbas-guide-to-m... The encoding/collation problem is now settled - the problem has been legacy, and especially, the somewhat mismanaged, rushed, change in 8.0.