Hi!
In "Environment", in Moodle 2.4.4, it is ok to migrate to Moodle 2.5. Database is in utf-8 Unicode is ok. But the migration to version 2.5 fails, reporting that the database is not in utf-8 unicode. Is this a bug in Moodle 2.5?
What encoding does mdl_config table have?
There is a useful script that should fix things: admin/cli/mysql_collation.php
Correct me if I'm wrong (likely!) but does the collation have anything to do with this check. Thought it was the encoding (or even the default encoding). His display isn't showing that, which doesn't help much.
You need to find and make sure the database 'character set' is UTF8. The collation is not the character set - it is the rules for comparing strings to each other.
Database charset is irrelevant since Moodle 2.5, the deciding factor is now charset and collation of the config table.
My wild guess is that config.php and screenshot might use different databse or prefix, the only other possibility seems config table chatset trouble - please verify the charset of all text fields in the config table too.
My wild guess is that config.php and screenshot might use different databse or prefix, the only other possibility seems config table chatset trouble - please verify the charset of all text fields in the config table too.
That's interesting, I'll add that to the FAQ (for when I forget)
But I have my Moodle on a webhost server. I only have access to phpMyAdmin via CPANEL. My Moodle has initialy made by Fantastico.
More than likely, when you made your database for Moodle 2.5 for the migration, you did not specify utf-8, so you have all your tables that migrated as utf-8, but not the database itself. Over the years I have done that myself a couple of times.
Hope this helps,
AL
Ok, thanks, but how do I convert the database via CPANEL?
I had to go back to the previous version (2.4.3+) and the strange thing is the OK to the 2.5 version in the environment section.
Yes I guess there is a bug, it always says same message "Check database unicode" while everything database and all tables are utf8_unicode_ci
I temporary continued by changing return type to 'true' in lib/dml/mysqli_native_moodle_database.php for
function setup_is_unicodedb()
changed return $return; to return true;
But there is a bug for sure.
Thanks