Laravel - How to change column type (smallInteger => string)

Question

The documentation doesn't say anything about changing data type with migrations.

I have this column in my DB table

$table->smallInteger('driverslicensetype')->nullable();

and I am saving four-digit numbers, but when the number begins with 0 (a zero) for example 0230 it will be saved as 230 in DB. And that is wrong.

Now i want to change this column data type from smallInteger to varchar.

How can i do this through migrations?

bishop · Accepted Answer · 2017-02-09 16:16:18Z

2

To use the schema changing feature, you need Doctrine DBAL:

composer require doctrine/dbal

Now you can use change():

public function up()
{
    Schema::table('foo', function (Blueprint $table) {
        $table->string('driverlicensetype', 4)->nullable()->change();
    });
}

public function down()
{
    Schema::table('foo', function (Blueprint $table) {
        $table->smallInteger('driverlicensetype')->nullable()->change();
    });
}

If you prefer the raw approach (or if your SQL is more restrictive, like when driverlicensetype is a foreign key), use DB::statement:

public function up()
{
    DB::statement('ALTER TABLE foo ...');
}
// ...

answered Feb 9, 2017 at 16:16

bishop

39.8k14 gold badges116 silver badges150 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

lewis4u Over a year ago

I got this error:

[Doctrine\DBAL\DBALException]                                                                         Unknown database type enum requested, Doctrine\DBAL\Platforms\MySQL57Platform may not support it.

bishop Over a year ago

@lewis4u Please ask this as a new question with the relevant code.

Collectives™ on Stack Overflow

Laravel - How to change column type (smallInteger => string)

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related