After installing files, to upgrade from 1.9 to 2.2.6 (Build: 20121112), I get the following server check: "It is required that you store all your data in Unicode format (UTF-8). New installations must be performed into databases that have their default character set as Unicode. If you are upgrading, you should perform the UTF-8 migration process (see the Admin page)." I wasn't expecting this because the database and all the tables are already set to utf8_general_ci . I thought utf8_general_ci was good enough. Any comments as to next steps would be appreciated.
I received the same error while installing a fresh Moodle 2.4.1 with new database. By default the MySQL database was set to utf_general_ci . Changed also to utf8_unicode_ci (recommended by Moodle), but still the same message. Tried also with an older version 2.3. of Moodle - same error! Had a year ago a running installation of Moodle 1.9 on that server at my webb-hotel without showing that error during installation.
Thanks for all help!
was able to solve the problem by running:
ALTER DATABASE mydatabasename charset=utf8; as decribed in
http://docs.moodle.org/23/en/Converting_your_MySQL_database_to_UTF8