Emoji Character is using an extended utf-8 Encoding, called UTF-8 mb4 (utf8mb4).
If inserting string with Emoji Character, the mysql will alert "incorrect string" and make the SQL fail.
To fix this, we need to:
- Change the database and table to utf8mb4 encoding
- Change the connection encoding to utf8mb4 as well