How Do I Use the utf8mb4 Character Set to Store Emojis in a GaussDB(for MySQL) Instance?

To store emoji in a GaussDB(for MySQL) instance, ensure that:

• The client outputs the utf8mb4 character set.
• The connection supports the utf8mb4 character set. If you want to use a JDBC connection, download MySQL Connector/J 5.1.13 or a later version and leave characterEncoding undefined for the JDBC connection string.
• Configure the instance as follows:
  • Setting character_set_server to utf8mb4

    

    1. Log in to the management console.
    2. Click in the upper left corner and select a region and a project.
    3. Click in the upper left corner of the page, choose Database > GaussDB(for MySQL).
    4. On the Instances page, click the instance name.
    5. In the navigation pane on the left, choose Parameters. On the Parameters tab page, locate character_set_server and change its value to utf8mb4.
    6. Click Save. In the displayed dialog box, click Yes.
  • Setting the character set of the table to utf8mb4

    

String query = "set names utf8mb4";
stat.execute(query);