MySQL support for iOS emoji emoticons

Reason:

The UTF-8 encoding can be two, three, and four bytes. The emoji expression is 4 bytes, while MySQL UTF8 encodes up to 3 bytes, so data cannot be plugged in.

Workaround:

Convert MySQL encoding from UTF8 to UTF8MB4

Steps:

1. Modify the MySQL configuration file My.ini

default-character-Set=utf8mb4character-set-SERVER=UTF8MB4

2. Join

[Client]port=3306default-character-Set=Utf8mb4[mysqld] Add character -Set-client-handshake= falsecollation-server= utf8mb4_general_ciinit_connect ='SET NAMES utf8mb4'

3. Restart MySQL

4. Change the input keyboard expression field encoding to Utf8mb4_general_ci

MySQL support for iOS emoji emoticons