Jarno Antikainen, an Experienced Software Engineer.
You might think that using UTF8 encoding and collation in MySQL or MariaDB would solve the character encoding issues for good. Wrong! In MySQL and MariaDB UTF8 is an alias to UTF8MB3, which means it cannot store four-byte character sequences. Whose idea was that?
So, use UTF8MB4 instead. Sigh.
I’m not going to explain it here, there are plenty of tutorials in the net. But I did find a possible bug in MariaDB and filed an issue.
I was trying to create a database migration in SQL, to add some events for entities that are saved in the database using event sourcing.