Help Center/ Relational Database Service_RDS for MySQL/ FAQs/ Database Parameter Modification/ How Do I Set the Encoding Format of the RDS for MySQL 8.0 Character Set?
Updated on 2026-05-14 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 RDS console.
    2. Click in the upper left corner and select a region.
    3. On the Instances page, click the instance name.
    4. In the navigation pane on the left, choose Parameters.
    5. Search for character_set_server and collation_server, respectively, in the search box.
    6. 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.
Parent Topic: Database Parameter Modification