MySQL complete Unicode compliance

By default MySQL only supports a subset of UTF-8, meaning that characters such as emoji are not handled properly.

Some extra steps at installation can be undertaken to leverage full Unicode support under MySQL.


Switching to complete Unicode compliance on an already-deployed database would typically involve delicate manual operations on the database system.


* MySQL >= 5.5

Strongly suggested MySQL configuration settings (innodb* parameters are mandatory):




Changing InnoDB parameters on an already deployed database server cancause severe data loss.

Do not blindly edit MySQL parameters without reading and understanding the implication of such changes.

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *