I haven't done this, but it should (might) work:
0/ Back up your database in case this doesn't work.
1/ In phpMyAdmin, click on the database name, click on the SQL tab, and enter "show tables;" and click the GO button. This should give you a list of all the table names.
2/ Copy the table names into a text editor, then change all the lines to:
ALTER TABLE `tablename` COLLATE utf8_unicode_ci;
where tablename is one of the table names.
3/ Copy the resulting text into phpMyAdmin's SQL tab, and click GO.
That should be it.
0/ Back up your database in case this doesn't work.
1/ In phpMyAdmin, click on the database name, click on the SQL tab, and enter "show tables;" and click the GO button. This should give you a list of all the table names.
2/ Copy the table names into a text editor, then change all the lines to:
ALTER TABLE `tablename` COLLATE utf8_unicode_ci;
where tablename is one of the table names.
3/ Copy the resulting text into phpMyAdmin's SQL tab, and click GO.
That should be it.
Back when the db went to utf there was a script to do this which I am sure is here still somewhere.
But the bigger problem is how the script did this as the migration scripts I thought specifically require utf now....
You may want to hold off doing anything til you are certain of what happened to your moodle on upgrade- if bluehost is converting the DBs to other than utf then they may eventually create a huge mess fortheir customers
But the bigger problem is how the script did this as the migration scripts I thought specifically require utf now....
You may want to hold off doing anything til you are certain of what happened to your moodle on upgrade- if bluehost is converting the DBs to other than utf then they may eventually create a huge mess fortheir customers