Help Center/ Relational Database Service/ FAQs/ Database Parameter Modification/ How Do I Set the Encoding Format of the RDS for MySQL 8.0 Character Set?
Updated on 2024-10-22 GMT+08:00
View PDF
Share

How Do I Set the Encoding Format of the RDS for MySQL 8.0 Character Set?

  1. Set character_set_server to utf8 and collation_server to utf8_general_ci.
    1. Log in to the management console.
    2. Click in the upper left corner and select a region.
    3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
    4. On the Instances page, click the instance name.
    5. In the navigation pane on the left, choose Parameters.
    6. Search for character_set_server and collation_server, respectively, in the search box.
    7. Set the parameters to utf8 and utf8_general_ci, respectively, and click Save.
  2. If you use a client of PHP 7.1.x, change the PHP version because it will fail to connect to MySQL 8.0 DB instances with the utf8mb4 character set.