How to convert string column type to integer using Laravel migration?

Question

I am trying to alter the column datatype using Laravel migration. But I am facing following error. Please help me out.

Schema::table('files', function(Blueprint $table) {
    $table->integer('app_id')->change();
    $table->index(['app_id', 'filename']);
});

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CHARACTER SET utf8 DEFAULT 0 NOT NULL COLLATE utf8_unicode_ci' at line 1 (SQL: ALTER TABLE files CHANGE app_id app_id INT CHARACTER SET utf8 DEFAULT 0 NOT NULL COLLATE utf8_unicode_ci)

Does this answer your question? Laravel migrations change a column type from varchar to longText — mighty_dev
– mighty_dev, Commented Nov 21, 2019 at 14:07
Not working for the following $table->integer('app_id')->change(); When I convert string to integer CHARACTER SET utf8 added automatically. How to remove this? — Nagarajan Malaichamy
– Nagarajan Malaichamy, Commented Nov 21, 2019 at 14:12
Do you have doctrine/dbal package in your laravel project? — mighty_dev
– mighty_dev, Commented Nov 21, 2019 at 14:14

Digital87 · Accepted Answer · 2020-01-26 17:51:38Z

14

As a alternative solution to https://github.com/doctrine/dbal/issues/3714 that is downgrading the doctrine/dbal package u can do:

Schema::table('member_section', function (Blueprint $table) {
    $table->bigInteger('type')->charset(null)->collation(null)->change();
});

answered Jan 26, 2020 at 17:51

Digital87

1731 silver badge5 bronze badges

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

Comments

Nicolas Buch · Accepted Answer · 2019-11-25 12:42:50Z

11

Your issue is most likely caused by a bug in the most recent version of the doctrine/dbal package. The issue was introduced with v2.10.0.

You can always downgrade the package in your composer.json to v2.9.3 it should work just fine.

See the offical issue here: https://github.com/doctrine/dbal/issues/3714

answered Nov 25, 2019 at 12:42

Nicolas Buch

5511 gold badge5 silver badges7 bronze badges

1 Comment

Ryan Over a year ago

Wow, I wasted hours on this before I finally found your post. Laravel and Doctrine each have been blaming each other. It's still not resolved. I'll just ignore for now. github.com/laravel/framework/issues/…

Collectives™ on Stack Overflow

How to convert string column type to integer using Laravel migration?

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related