Installing and upgrading help

Hi François,

First of all, if you check both messages, one says "must" and the other says "should". Then, you only need to fix the first one (Unicode) to get you upgrade running.

Regarding your question about moodle22, yes, that refers to the name of your moodle database and so you need to modify that text to correspond to your actual database name.

--- 

It is a bit surprising that you are getting a Unicode error, as your Moodle 2.0.3 database should already be complying with this requirement.

Anyway, as you are upgrading (i.e. working with a previous database), statements like:

ALTER DATABASE db_name DEFAULT CHARACTER SET charset_name DEFAULT COLLATE collation_name;

ALTER TABLE tbl_name DEFAULT CHARACTER SET charset_name COLLATE collation_name;

will not change your data, they will only define the character set and the collation to be used on new tables and new columns, respectively.

While you can first execute (in phpMyAdmin) the following SQL statement:

ALTER DATABASE db_name DEFAULT CHARACTER SET charset_name DEFAULT COLLATE collation_name;

and then the following for each table:

ALTER TABLE tbl_name CONVERT TO CHARACTER SET charset_name COLLATE collation_name;

you could actually risk mangling your database (for a number of reasons). Instead, you should use the MODIFY clause to change each and every individual text type (char, varchar, text, etc.) column required (i.e those columns not in utf8) of each and every table, like so:

ALTER TABLE tbl_name MODIFY col_name  col_type CHARACTER SET charset_name COLLATE collation_name;

Of course, to do that, you would first need to determine which columns actually need to be updated and then update them.

--- 

Please start by running the following three SQL queries in your phpMyAdmin:

SELECT schema_name, default_character_set_name "character_set", default_collation_name "collation"
FROM information_schema.schemata
WHERE schema_name = 'db_name';

SELECT t.table_name, ccsa.character_set_name "table_character_set", t.table_collation
FROM information_schema.`tables` t,
information_schema.`collation_character_set_applicability` ccsa
WHERE ccsa.collation_name = t.table_collation
AND t.table_schema = 'db_name';

SELECT table_name, column_name, data_type, character_set_name, collation_name, column_type
FROM information_schema.columns
WHERE table_schema = 'db_name'
AND data_type IN ('char', 'varchar', 'tinytext', 'text', 'mediumtext', 'longtext', 'enum', 'set');

save the results of each query into an Excel file (using the Export link), take note of the character set and collation of the database, the tables and the columns, and report back.

---

Finally:

• Regarding the intl php_extension issue, that cannot be fixed via phpMyAdmin. You, or your service provider, need to enable it by installing the extension (a Windows "intl.dll" file or a Unix "intl.so" file) and modifying the php.ini configuration file.
• And the 'admin' page in question is: http://docs.moodle.org/23/en/admin/