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

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.
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.
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.

Была ли эта статья полезна?