






<?php

$rs2 = mysql_query("SHOW DATABASES");
if(!$rs2)
{
    echo "\n\n".$sq."\n".mysql_error()."\n\n";
} else {
    while ($data2 = mysql_fetch_row($rs2))
    {
        $db=$data2[0];
        $db_cha=PMA_getDbCollation($db);

        if ( $db == 'mysql' OR $db == 'information_schema' ) continue;
        if ( $limitDB AND !in_array($db, $DBnames) ) continue;

        if ( substr($db_cha[0],0,4)!='utf8' )  
        {
            mysql_select_db($db);
            $rs = mysql_query("SHOW TABLES");
            if(!$rs)
            {
                echo "\n\n".$sq."\n".mysql_error()."\n\n";
            } else {
                while ($data = mysql_fetch_row($rs))
                {
                    $rs1 = mysql_query("SHOW FULL COLUMNS FROM $data[0]");
                    if(!$rs1)
                    {
                        echo "\n\n".$sq."\n".mysql_error()."\n\n";
                    } else {
                        while ($data1 = mysql_fetch_assoc($rs1))
                        {
                            if(in_array( array_shift( split("\\(",$data1['Type'],2) ), $fieldTypes ) )
                            {
                                //if(substr($data1['Collation'],0,4)!='utf8') 
                                //{
                                    //$sq = "ALTER TABLE  CHANGE `"..'` `'.$data1['Field'].'` '.$data1['Type'].' CHARACTER SET binary '.($data1['Default']==''?'':($data1['Default']=='NULL'?' DEFAULT NULL':' DEFAULT \''.mysql_escape_string($data1['Default']).'\'')).($data1['Null']=='YES'?' NULL ':' NOT NULL');
									$sq = "ALTER TABLE `{$data[0]}` CHANGE `{$data1['Field']}` `{$data1['Field']}` BLOB";
                                    if( !$printonly && !mysql_query($sq) )
                                    {
                                        echo "\n\n".$sq."\n".mysql_error()."\n\n";
                                    } else {
                                        echo ( $sq . ";\n") ;
                                        //$sq = "ALTER TABLE  CHANGE `".$data1['Field'].'` `'.$data1['Field'].'` '.$data1['Type']." CHARACTER SET $charset ".($collate==''?'':"COLLATE $collate").($data1['Default']==''?'':($data1['Default']=='NULL'?' DEFAULT NULL':' DEFAULT \''.mysql_escape_string($data1['Default']).'\'')).($data1['Null']=='YES'?' NULL ':' NOT NULL').($data1['Comment']==''?'':' COMMENT \''.mysql_escape_string($data1['Comment']).'\'');
                                        $sq = "ALTER TABLE `{$data[0]}` CHANGE `{$data1['Field']}` `{$data1['Field']}` {$data1['Type']} CHARACTER SET utf8";
										if( !$printonly && !mysql_query($sq))
                                        {
                                            echo "\n\n".$sq."\n".mysql_error()."\n\n";
                                        } else {
                                            echo ($sq.";\n") ;
                                        }
                                    }
                                //}
                            }
                        }

                        if($altertablecharset)
                        {
                            $sq='ALTER TABLE `'.$data[0]."` DEFAULT CHARACTER SET $charset ".($collate==''?'':"COLLATE $collate");

                            //echo ($sq.";\n") ;

                            if(!$printonly)
                            {
                                if(!mysql_query($sq)) echo "\n\n".$sq."\n".mysql_error()."\n\n";
                            }
                        }
                    }
                }

                if($alterdatabasecharser)
                {
                    $sq='ALTER DATABASE `'.$data2[0]."` DEFAULT CHARACTER SET $charset ".($collate==''?'':"COLLATE $collate");

                    echo ($sq.";\n") ;

                    if(!$printonly)
                    {
                        if(!mysql_query($sq)) echo "\n\n".$sq."\n".mysql_error()."\n\n";
                    }
                }
            }
        }
    }
}
?>