Implemented True UTF-8 support - MySQL utf8mb4

[Xon]

MySQL's utf8 data type only supports 3-byte characters, not the full 4 byte characters.

MySQL only recently as of MySQL 5.5 now supports the full UTF-8 encoding set via the table coolation type utf8mb4.

This means ios emoji icons (and likely other mobile devices who move to offer the same support) and non-English characters are impacted.

After derailing a support ticket, and seeing it happening to another one;

• https://xenforo.com/community/threads/some-unicode-characters-not-recognized.89945/
• https://xenforo.com/community/threads/emoji-icons-posting-from-ios-devices-to-xenforo.25722/

People involved in those last threads who may be interested: @RobinHood, @Tracy Perry, @cclaerhout, @Omar Bazavilvazo @tyteen4a03

 

[Chris D]

This is implemented in XF 2.0.

The minimum system requirements for XenForo 2.0 have changed as a result and you should be running MySQL 5.5 and above. Because it is a potentially intensive operation, it's not something we handle during upgrade or via the web interface, but it is the default for new installs.

For existing installs upgrading to XF 2.0, after the upgrade you need to run the following command from your shell:

php cmd.php xf:convert-utf8mb4

 

[Sunka]

and we should be in dir???

 

[Chris D]

Yes, i guess the following is more accurate:

php /path/to/xenforo/root/cmd.php xf:convert-utf8mb4