DB tables don't agree on collation

NEW
Unassigned

Status

support.mozilla.org
Code Quality
P3
normal
7 years ago
6 years ago

People

(Reporter: erik, Unassigned)

Tracking

Firefox Tracking Flags

(Not tracked)

Details

(Reporter)

Description

7 years ago
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.
Target Milestone: 2011Q1 → 2011Q2
Target Milestone: 2011Q2 → 2011Q3
Target Milestone: 2011Q3 → ---
You need to log in before you can comment on or make changes to this bug.