I just stumbled upon this problem, which was due to fields in some tables having conflicting collations. Thanks to the answer to that question I solved our immediate problem.
But looking around I see a lot of fields in a lot of tables have differing collations. Should I fix all those too, or does that create a risk for other problems?
If I should "reset" all collations, is there a simple way to do that with all fields in all tables without cv
(which we currently don't have)?