I recently upgraded to moodle 1.7 via c-panel. I selected "Japanese" and "English " language packs ,but when I go to write in Japanese say for example in assignment activity, when I save it , it then appears as "??????". Does anyone have a solution to this problem?
Cheers
Robert
Could you find the Moodle install directory?
Then go to "lib" directory in the Moodle install directory.
The script file you need to modify is "dmlib.php" in "lib" directory.
Open dmlib.php and go to line 1909.
And modify the "code" as below.
[Before]
switch ($CFG->dbtype) {
case 'mysql':
/// Set names if needed
if ($CFG->unicodedb) {
$db->Execute("SET NAMES 'utf8'");
}
break;
[After]
switch ($CFG->dbtype) {
case 'mysql':
/// Set names if needed
if ($CFG->unicodedb) {
// $db->Execute("SET NAMES 'utf8'");
}
break;
Then go to "lib" directory in the Moodle install directory.
The script file you need to modify is "dmlib.php" in "lib" directory.
Open dmlib.php and go to line 1909.
And modify the "code" as below.
[Before]
switch ($CFG->dbtype) {
case 'mysql':
/// Set names if needed
if ($CFG->unicodedb) {
$db->Execute("SET NAMES 'utf8'");
}
break;
[After]
switch ($CFG->dbtype) {
case 'mysql':
/// Set names if needed
if ($CFG->unicodedb) {
// $db->Execute("SET NAMES 'utf8'");
}
break;
My Pleasure 
When we use multibyte character as Japanese, we had better set MySQL collation to 'utf8_unicode_ci' or 'utf8_general_ci'.
Please read MoodleDocs for more detail.
http://docs.moodle.org/en/Installing_Moodle
When we use multibyte character as Japanese, we had better set MySQL collation to 'utf8_unicode_ci' or 'utf8_general_ci'.
Please read MoodleDocs for more detail.
http://docs.moodle.org/en/Installing_Moodle