<?php
define('_VALID', true);
require 'libraries/bootstrap.php';
$db = VF::factory('database');
$db->query("ALTER DATABASE ".VF::cfg_item('db_name')."
CHARACTER SET utf8
DEFAULT CHARACTER SET utf8
COLLATE utf8_general_ci
DEFAULT COLLATE utf8_general_ci");
$db->query("SHOW TABLES");
$tables = $db->fetch_rows();
foreach ($tables as $table) {
$name = $table['0'];
$db->query("ALTER TABLE ".$name."
DEFAULT CHARACTER SET utf8
COLLATE utf8_general_ci");
}
VF::close();
?>
Save the above code in a php file (utf8.php for example). Upload the file to your server and access domain.com/utf8.php
]]>I will start on Japanese and Spanish. Will the script support non-latin languages i.e. character based?
I Think No I Tried Hindi But Its Not Supporting It. Some Problem In It But Let Others Comment also Before You Start Working on It.