1366 Incorrect string value fix via migrations?

Question

MySQL

There was a problem, when saving the text ( Cyrillic ) to the database, an error 1366 Incorrect string value crashes .
The Yii2 database configs are set to 'charset' => 'utf8' .
The question is how to fix this with migrations?

Answer 1

You need to add to the migration:

$this->alterColumn('table.name', 'table.column', $this->string()->append('CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL'));