3 ms·

How to support full Unicode in MySQL databases

• taspeotis 6y ago
  (2012)
  • shock 6y ago
    Still relevant in 2020.
• jedimastert 6y ago
  This was a somewhat interesting problem for the emoji-only chat service "Emoj.li" https://www.youtube.com/watch?v=GsyhGHUEt-k https://www.youtube.com/watch?v=GsyhGHUEt-k
• 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 ago
    as 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 ago
      This 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.