I'm trying to intall Moodle 2.0.8 and it's giving me an error telling me that I have to solved it before continuing. It tell me that I need to activate UTF-8 on MySQL, but my server provider say that it's on...What can I do?
There can be an issue here with cPanel and Fantastico. For some reason it can sometimes make the default latin_swedish_ci. I thought we had gotten past this but perhaps not..
To check, and if you are using cPanel, open phpMyAdmin and look at your database. It should tell you what the collation is, it should be utf-8_unicode_ci. To fix the issue, in phpMyAdmin, go to the SQL Tab and enter the line Visvanath has written above, obviously dbname is the name of your database. Also, the type should be InnoDB.
Thank you very much for both respons.
I have wrote this line on phpMyAdmin:
mysql> ALTER DATABASE talearning DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
And I got this respons of phpMyAdmin:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql> ALTER DATABASE talearning DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode' at line 1
In a second oportunity, I just enter:
ALTER DATABASE my-database-name DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
And it works, because it's not giving me this error any more, and I have finish installing my Moodle.
Thank you very much
Caveat: Don't eat the menu!
Anyway that solved, there might be a second problem: the MySQL "engine". Moodle moved some time back from MyISAM to InnoDB. That is what Coin mentioned. I hope in your fresh install you have InnoDB. Otherwise keep an eye on http://docs.moodle.org/en/Migration_from_MyISAM_to_InnoDB.