Need some help with DB collation woe
hman wrote:
Maybe I should add that the contents of the DB look absolutely okay, nothing is visibly damaged. The Tiki contains mostly text, written in German. Besides text, there are some images in the DB and even some MPEG movies, all look okay.
Hi @hman
Glad your data is ok, as far as i understand it, the collation only affects sorting, and the benefits for utf8_unicode_ci
over utf8_general_ci
is it's better at sorting non-ascii characters, especially capitalised ones, so a probable fix (after taking a restorable backup ;) would be to change the collation on the utf8_general_ci
tables and fields to utf8_unicode_ci
.
Which version of MySQL are you on? Maybe a minor update made it more sensitive to this?