When you upgrade to the latest Moodle version you may get a warning about incorrect MySql collation. The upgrade process should automatically convert the MySql collation. However, if this does not happen you can do it manually by going to:
http://yourmoodlesite/admin/utfdbmigrate.php
Before this process begins, it creates a backup of your database in case the conversion fails.
You need help with an application? hostlantern is specialized in hosting and supporting more than 200 scripts. Sign up for our web hosting services and let us help you with your application, 24/7!