Hallo i have a problem with installation moodle 2 and it displays this message :" 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)." what i have tochange ?
Hi
I found this thread useful to fix my collation and character set during an upgrade of moodle
http://moodle.org/mod/forum/discuss.php?d=153914
I used something like this to make my database in mysql
create database moodle2 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
I then imported my sql database into this new database
and used the change_collation.pl perl script discussed in the above thread.
I did need to adjust the names of the database in the script though.
I had an sql file which gave error about illegal collations and the
script fixed them for me.
I am using linux you need perl installed i think.