Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I recently setup mysql 5.5.20 database in Amazon RDS with movable type but actual character encoding doesn't take effect. I change the parameter group setting to utf8 like below.

character-set-client-handshake = yes
character_set_client  = utf8
character_set_connection = utf8
character_set_database = utf8
character_set_filesystem = binary
character_set_results = utf8
character_set_server = utf8
collation_connection = utf8_general_ci
collation_server = utf8_general_ci
init_connect = SET NAMES utf8

When I build Movable Type 5.13 database table encodeing is cp1252_West_Europe and collation is labeled latin1_swedish_ci but actually should be UTF-8 Unicode and utf8_general_ci

What am I doing wrong?

share|improve this question
    
Are you sure it isn't just Movable Type that's creating the fields with that encoding? –  gekkz Feb 29 '12 at 10:02
    
I tried CREATE TABLE manually and still gives me cp1252_West_European and latin1_swedish_ci –  Maca Feb 29 '12 at 11:35
add comment

1 Answer

up vote 1 down vote accepted

Okay I got it.

RDS by default sets its encoding to latin8 ignoring the parameter group that you created. So I just needed to delete the first DB that you have to set from the AWS dashboard.

share|improve this answer
    
You don't need to delete the DB. You can just switch the Paramter Group and RDS dashboard will ask you to reboot the instance. –  Knots Apr 23 at 22:13
    
Oh, almost forgot, you can switch the Parameter Group by selecting "Modify" in the Instance Actions dropdown. –  Knots Apr 23 at 22:22
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.