MySQL 编码是 latin1, rails 编码 utf8，如何解决中文乱码问题

Question

MySQL 编码是 latin1, rails 编码 utf8，如何把 rails 编码 utf8 转换成 latin1，解决中文乱码问题

mysql
show variables like 'char%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+

select * from auto_brands;
+----+--------+---------------------+---------------------+
| id | brand | created_at | updated_at |
+----+--------+---------------------+---------------------+
| 1 | 本田 | 2011-06-02 05:49:43 | 2011-06-02 05:49:43 |
| 2 | 宝马 | 2011-06-02 05:56:32 | 2011-06-02 05:56:32 |
+----+--------+---------------------+---------------------+

database.yml
development:
adapter: mysql2
encoding: latin1
database: meiying_china_development
pool: 5
username: root
password: 123
socket: /var/run/mysqld/mysqld.sock

Answer 1

建议把环境统一成 UTF-8，这样比 latin1 <=> UTF-8 转换简单。

Answer 2

不要用latin1,全部用utf8,方便管理,毕竟咱生在中国无法避免用到中文