Ruby on Rails

On Mon, Jan 5, 2015 at 10:00 AM, Kriti Aggarwal <krit...@gmail.com> wrote:
> Following are the encodings/collations and versions that I am using:
> Rails : utf8, 4.0
> Mysql: latin_general_ci, 14.14 Distrib 5.5.40

Well, it should be pretty obvious you have a mismatch there, which is
a problem. But there's not just one encoding-related variable. Example:

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       |
/usr/local/mysql-5.6.13-osx10.7-x86_64/share/charsets/ |
+--------------------------+--------------------------------------------------------+
8 rows in set (0.00 sec)

mysql> show variables like '%coll%';
+----------------------+-----------------+
| Variable_name        | Value           |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database   | utf8_general_ci |
| collation_server     | utf8_general_ci |
+----------------------+-----------------+
3 rows in set (0.01 sec)

You want, at the least, all of those consistent. If you need the 4-byte
character capability, then set them appropriately.

Note: you'll need to manually alter (or drop and recreate) existing
databases/tables afterwards.

HTH,
--
Hassan Schroeder ------------------------ hassan.s...@gmail.com
http://about.me/hassanschroeder
twitter: @hassan