Help Center/ Relational Database Service/ User Guide (Ankara Region)/ FAQs/ Database Connection/ How Do I Set the Encoding Format of the MySQL 8.0 Character Set?
Updated on 2024-04-11 GMT+08:00
View PDF
Share

How Do I Set the Encoding Format of the 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 Service List. Under Database, click Relational Database Service. The RDS console is displayed.
    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.
Parent topic: Database Connection