gistfile1.txt

<?php

class Altertabletoutf8 extends Doctrine_Migration_Base
{
  public function up()
  {
    Doctrine::loadModels(sfConfig::get('sf_lib_dir').'/model/doctrine');
    $q = Doctrine_Manager::getInstance()->getConnection('doctrine');
    
    foreach (Doctrine::getLoadedModels() as $model)
    {
      $tableName = Doctrine::getTable($model)->getTableName();
      $connectionName = Doctrine::getTable($model)->getConnection()->getName();
      if ($connectionName == 'doctrine')
      {
        $result = $q->execute(sprintf("ALTER TABLE %s CONVERT TO CHARACTER SET utf8", $tableName));
      }
    }
  }

  public function down()
  {
  }
}