I've MySQL database and site files (public_html). I'm trying to reload the OS from scratch. To restore IPB, do I need to just restore the database and upload all site files. Is it requires any other configuration steps? I'm restoring on same server hardware, same site address and same ip. Any quick help would be greatly appreciated. Thank you!
You can only query on fields with the same collation. You have to change the default collation to UTF-8 in problematic tables. At this point, it is a bug in MySQL ( http://bugs.mysql.com/bug.php?id=15949 ) - I suggest you to upgrade MySQL to latest stable version. Also try to update PHP (be cautious while upgrading to latest stable version since it will override any custom PHP settings).