// prekonvertovani kompletne vseho na UTF
// 1. db
// 2. tabulky
// 3. sloupce tabulek 

$character_set = "utf8";
$collate = "utf8_czech_ci";

// nejdrive databazi
dibi::query('ALTER DATABASE `'.$db['database'].'` DEFAULT CHARACTER SET '.$character_set.' COLLATE '.$collate);

// pak vsechny tabulky
$result = dibi::query('SHOW tables');
foreach ($result as $n => $row) {
    echo $tab = $row['Tables_in_'.$db['database']];
    
    exit;
    // zmenim kodovani tabulce
    dibi::query('ALTER TABLE `'.$tab.'` DEFAULT CHARACTER SET '.$character_set.' COLLATE '.$collate);
	// zjistim sloupce tabulky
    $result2 = dibi::query("SHOW COLUMNS FROM ".$tab);
    // a uvnitr tabulek pak i sloupce
    foreach ($result2 as $row1) {
        if (preg_match('~char|text|enum|set~', $row1["Type"])) {
            dibi::query("ALTER TABLE `".$tab."` CHANGE `".$row1[Field]."` `".$row1[Field]."` ".$row1["Type"]." CHARACTER SET ".$character_set." COLLATE ".$collate." NULL DEFAULT NULL");
            //ALTER TABLE `newsletter` CHANGE `captions` `captions` TEXT CHARACTER SET utf8 COLLATE utf8_czech_ci NULL DEFAULT NULL
        }    	
    }
    
    echo "tab ".$tab." hotova".BR;
    flush(); flush();

}