Help Center/ Relational Database Service/ User Guide (Ally Region)/ FAQs/ Database Parameter Modification/ How Do I Set the Encoding Format of the RDS for MySQL 8.0 Character Set?
Updated on 2025-12-26 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 and a project.
    3. Click in the upper left corner of the page and choose Database > 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. Modify the values 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.