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 Databases > 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.
  • Selecting utf8mb4 for database character set
    1. On the Instances page, locate the instance and click Log In in the Operation column.

       Alternatively, on the Instances page, click the instance name to go to the Basic Information page. Click Log In in the upper right corner of the page.

    2. On the displayed login page, enter the correct username and password and click Log In.
    3. On the Databases page, click Create Database. In the displayed dialog box, enter a database name, select the character set utf8mb4, and authorize database permissions for users. Then, click OK.
       Figure 1 Creating a database
       
  • Setting the character set of the table to utf8mb4

    

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