Need some help with DB collation woe
On my newer Tiki 18.8 the default is also utf8_general_ci. But there all tables are utf8_unicode_ci, expect for ONE:
index_pref_de is utf8_general_ci. So the bug is not limited to one of the upgrader scripts, but is within initial creation script as well, just smaller...