Database schema error - don't know when it started, or why... clues gratefully accepted

Help
3

Please check the thread => MySQL tables collation is wrong - #2 by Jellyfrog