How to configure the Amazon RDS to store Chinese Characters in the right way? Currently the text all becomes '????'.
I already created new parameter group and set character set as utf8 and modify the instance. Below are the detail info:
mysql> show variables like '%char%';
+--------------------------+-------------------------------------------+
| Variable_name | Value |
+--------------------------+-------------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /rdsdbbin/mysql-5.5.27.R1/share/charsets/ |
+--------------------------+-------------------------------------------+
+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_unicode_ci |
+----------------------+-----------------+
Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/ . In the navigation pane, choose Automated backups. On the Current Region tab, choose the DB instance for which you want to enable backup replication. For Actions, choose Manage cross-Region replication.
RDS Aurora MySQL can outperform RDS MySQL by up five times in synthetic benchmark tests, and offers noticeable performance improvements in real world workflows. There are no compatibility issues between RDS Aurora MySQL and RDS MySQL, since both are built using generally available MySQL open-source software.
After following @Peter Venderberghe's answer to configure RDS, I still can not let it store Chinese characters correctly.
Finally, I used mysql command line to connect to RDS (you can use mysql workbench or other client tool you like)
mysql -u USERNAME -pPASSWORD -h HOSTNAMEORIP DATABASENAME
note:
1). remember to add your current ip to security group inbound of RDS before connecting to RDS
2). you can get related information(security groups, USERNAME
...etc) on RDS console besides PASSWORD
. PASSWORD
should be the one you created for the instance. HOSTNAMEORIP
is "Endpoint"(without the port) on the console.
3). there is no space between -p and PASSWORD. it's exactly -pPASSWORD
.
After connecting to mysql with the tool you are comfortable with, you need to give it some commands:
# set character set and collation for database
mysql> alter database DATABASENAME CHARACTER SET utf8 COLLATE utf8_unicode_ci;
--------
# set character set and collation for new records in a table
mysql> ALTER TABLE TABLENAME CHARACTER SET utf8 COLLATE utf8_unicode_ci;
# set character set and collation for existing records in a table
mysql> ALTER TABLE TABLENAME CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
you may want to write a script to do this task if you have many tables. However, it's not in the scope of this answer.
After configuring as above, you should be able to rock with Chinese characters!
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With