How to Get Emojis in MySQL (fixing Incorrect String Value)
So your Rails application with a MySQL database was humming along and all of a sudden it hit this error: Mysql2::Error: Incorrect string value: '\xC5\x99\xC3\xA1k...
So your Rails application with a MySQL database was humming along and all of a sudden it hit this error: Mysql2::Error: Incorrect string value: '\xC5\x99\xC3\xA1k...
Make a quick dump of a mysql database: mysql_dump db_name > backup-file.sql You can then read that dump file back into the server like this...
First, isntall MySQL package installer from http://dev.mysql.com/downloads/mysql/5.1.html#downloads DON'T DOWNLOAD THE 64-BIT VERSION!!! You must download the 32-bit version even if you have a 64-bit machine....