Solution to Support Additional Unicode Characters
Problem: MySQL databases set to utf8 can only store characters from the Unicode BMP (Basic Multilingual Plane). Therefore characters outside of the BMP can not be shown.
This is important for support of: Unicode Plane 2, used for Chinese/Japanese/Korean Ideographs, mostly CJK Unified Ideographs, that were not included in earlier character encoding standards, and Unicode Plane 1 used for Ancient Scripts, Symbols and Emoji.
Solution: use the utf8mb4 character set. utf8mb4 is a superset of utf8.