Features / Usability

Features / Usability

Need some help with DB collation woe

posts: 126825 United Kingdom
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?