633053 - DB tables don't agree on collation

Status: RESOLVED WONTFIX

(support.mozilla.org :: Code Quality, task, P3)

Description

[Erik Rose [:erik][:erikrose]]

The situation now on my laptop:

mysql> use information_schema ;
mysql> SELECT COUNT(*), TABLE_COLLATION FROM tables WHERE TABLE_SCHEMA = 'sumo0720' GROUP BY table_collation;
+----------+-------------------+
| COUNT(*) | TABLE_COLLATION   |
+----------+-------------------+
|        1 | latin1_swedish_ci |
|       20 | utf8_general_ci   |
|       24 | utf8_unicode_ci   |
+----------+-------------------+
3 rows in set (0.07 sec)


This is bad because it makes queries fail which try to compare across columns of differing collation. Apparently, we aren't doing this now, or the situation on stage and prod is better.