Latin1 encoded tables or databases with UTF8 data stored: convert them to native mysql UTF8 Tables/Database

hi i have done some changes on the script and it works like a charm , but there is only one small problem on it

as i have read on the word press i think :/?

The string field types need to be converted to their binary field types counterparts.
The list is as follows:

CHAR -> BINARY
VARCHAR -> VARBINARY
TINYTEXT -> TINYBLOB
TEXT -> BLOB
MEDIUMTEXT -> MEDIUMBLOB
LONGTEXT -> LONGBLOB

but your script will change all the defined fields in the second part to text filed at last. i know it is not so much hard to change whloe script for different types of them with different defined fileds.

but i dont have the knowledge to convert your script to an automated script that detects relevant filed types and converts them accordingly :D

its just an idea and i dont know how to do it because i'm a mechanical engineer not a computer programmer.
but as a fan of scripting this idea is not a bad one :D

i have tried so many free or commercial database and mysql converter programs but none could do this job correctly.

thanks for your great help.& best wishes.

and here is my little more completed script

<--start php here 
/*
Please Dont delete any of these comments . 
*/
//define your user name and password here

$hostname = 'localhost';
$username = 'root'; //your user name
$password = 'farzin'; // your password 
$pre= "nuke_"; //your nuke database prefix  , example "nuke_" attention : dont forget to type the "_" if it is used in the prefix.
$dbname="nukeevo21"; //your database name

$db = mysql_connect($hostname, $username, $password)
  or die("Unable to connect to MySQL");
  
//Define Tables and  fields here
$table_fields = array(
  ($pre.'authors') => array('name'),
  ($pre.'banner') => array('alttext'),
 );

convert_to_utf8($dbname, $table_fields);


//and here is the script , do not modify anything after here...
/**
 * Converts fields contained into $fields array on the table $table on the db $dbname to blob and then to utf8.
 * This is the procedure to follow when convert the field encoding when it's different than utf8 (eg latin1) while it already contains utf8 data inside
*/
function convert_to_utf8($dbname, $tables_fields) {

  foreach($tables_fields as $table => $fields) {
    foreach($fields as $field) {
      // convert each field to BLOB
      myq('ALTER TABLE ' . $dbname . '.' . $table . ' MODIFY ' . $field . ' BLOB');
    }
  }
  myq("ALTER DATABASE $dbname charset=utf8");
  
  foreach($tables_fields as $table => $fields) {
    myq('ALTER TABLE ' . $dbname . '.' . $table . ' charset utf8');
  }
  
  foreach($tables_fields as $table => $fields) {
    foreach($fields as $field) {
      // convert each field to utf8
      myq('ALTER TABLE ' . $dbname . '.' . $table . ' MODIFY ' . $field . ' TEXT CHARACTER SET utf8');
    }
  }
  
  print "< div align='center'>< strong>DataBase " . $dbname ." :< /strong>< font color='green'> successfully< /font> converted to utf8 .
  < br>< br>written by < a href='mailto: fvaresano [at] yahoo [dot] it'>Fabio Varesano< /a> < br>
and converted & completed by < a href='mailto: farzin [dot] sb [at] gmail [dot] com'>Farzin sadeghi < /a>< /div>\n";
}

function myq($query) {
  $result = mysql_query($query) or die("error: " . mysql_error() . "\nQuery: " . $query);
  return $result;
}


  
  --end php here>

in the preview i have seen some coding mistakes .

i think this one solves the problem .
sorry admin, please delete my last comment.
i didnt know what does

 could do :D i've learned now b-( :P