Created
March 10, 2016 20:48
-
-
Save amccarty/86aa3873d9baa40c7482 to your computer and use it in GitHub Desktop.
Amazon RDS uft8 encoding
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| aws rds create-db-parameter-group --db-parameter-group-name mysql-utf8 --db-parameter-group-family mysql5.6 --description "MySQL 5.6 configured for UTF-8" | |
| aws rds modify-db-parameter-group --db-parameter-group-name mysql-utf8 \ | |
| --parameters="ParameterName=character_set_server, ParameterValue=utf8, ApplyMethod=immediate" \ | |
| --parameters="ParameterName=character_set_client, ParameterValue=utf8, ApplyMethod=immediate" \ | |
| --parameters="ParameterName=character_set_results, ParameterValue=utf8, ApplyMethod=immediate" \ | |
| --parameters="ParameterName=collation_server, ParameterValue=utf8_unicode_ci, ApplyMethod=immediate" \ | |
| --parameters="ParameterName=collation_connection, ParameterValue=utf8_unicode_ci, ApplyMethod=immediate" | |
| # Apply to an existing instance (followed by a reboot): | |
| aws rds modify-db-instance --db-instance-identifier DB_NAME --db-parameter-group-name mysql-utf8 | |
| aws rds reboot-db-instance --db-instance-identifier DB_NAME |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Doesn't work for mysql8 RDS. Gonna look at tweaking it.
EDIT: Just changed the family to mysql8.0