engelsystem/db/migrations/2019_06_12_000000_fix_user_languages.php

<?php

declare(strict_types=1);

namespace Engelsystem\Migrations;

use Engelsystem\Database\Migration\Migration;

class FixUserLanguages extends Migration
{
    /**
     * Run the migration
     */
    public function up(): void
    {
        $connection = $this->schema->getConnection();
        $connection
            ->table('users_settings')
            ->update([
                'language' => $connection->raw('REPLACE(language, ".UTF-8", "")'),
            ]);
    }

    /**
     * Reverse the migration
     */
    public function down(): void
    {
        $connection = $this->schema->getConnection();
        $connection
            ->table('users_settings')
            ->update([
                'language' => $connection->raw('CONCAT(language, ".UTF-8")'),
            ]);
    }
}