Telos

Mysql2::Error: Illegal mix of collations:

Mysql2::Error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=': SELECT -- ...

show full columns from some_table;
+---------------+--------------+-----------------+------+-----+---------+----------------+---------------------------------+---------+
| Field         | Type         | Collation       | Null | Key | Default | Extra          | Privileges                      | Comment |
+---------------+--------------+-----------------+------+-----+---------+----------------+---------------------------------+---------+
| something     | varchar(255) | utf8_general_ci | NO   |     | NULL    |                | select,insert,update,references |         |

mysql> show create table some_other_table;
+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table     | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|some_other | CREATE TABLE ` some_other_table` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  ...
) ENGINE=InnoDB AUTO_INCREMENT=92 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci |
+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

ALTER TABLE some_other_table CHARACTER SET utf8 COLLATE utf8_unicode_ci;

error: Untracked working tree file [file] would be overwritten by merge: This may save you some time [if you can get away with it].

git clean -f [file]

The Goal:

Return stale data for a period of time and asynchronously refresh this data.