RDSで誰もが一度ハマるcharacter_set_database latin1をutf8にする

gistfile1.txt

>show variables like 'character_set_database';
+--------------------------+-------------------------------------------------------+
| Variable_name            | Value                                                 |
+--------------------------+-------------------------------------------------------+
| character_set_database   | latin1                                                  |
+--------------------------+-------------------------------------------------------+


>alter database {database_name} default character set utf8;

>show variables like 'character_set_database';
+--------------------------+-------------------------------------------------------+
| Variable_name            | Value                                                 |
+--------------------------+-------------------------------------------------------+
| character_set_database   | utf8                                                  |
+--------------------------+-------------------------------------------------------+

Tableは作り直すか下記のDDLを実行する

ALTER TABLE {table_name} CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;