$ce = DB_DataObject::factory('core_enum');
// not sure why, but convert to does not actually change the 'charset=' bit..
- $ce->query("ALTER TABLE $tbl CHARSET=utf8");
- $ce->query("ALTER TABLE {$tbl} CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci");
+ $ce->query("ALTER TABLE `$tbl` CHARSET=utf8");
+ $ce->query("ALTER TABLE `{$tbl}` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci");
echo "utf8: FIXED {$tbl}\n";
}
//as the default collation for stored procedure parameters is utf8_general_ci and you can't mix collations.
$ce = DB_DataObject::factory('core_enum');
- $ce->query("ALTER TABLE $tbl ENGINE=InnoDB");
+ $ce->query("ALTER TABLE `$tbl` ENGINE=InnoDB");
echo "InnoDB: FIXED {$tbl}\n";
}