Convert tables to the required collation in Yii2

converTablesToCollation.php

$wantedCollation = 'utf8_unicode_ci';

        $command = Yii::$app->getDb()->createCommand('SHOW TABLE STATUS');

        $tableCollations = $command->queryAll();


        if (!empty($tableCollations)) {
            foreach ($tableCollations as $tableCollation) {
                $tableName = $tableCollation['Name'] ?? null;
                $collation = $tableCollation['Collation'] ?? null;

                if ($tableName && $collation !== null && trim($collation) !== $wantedCollation) {
                    $sql = "ALTER TABLE $tableName CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;";

                    $this->execute($sql);
                }
            }
        }