How to convert string to boolean in laravel migration?

Question

I want to convert a field from string to boolean trying this code:

 public function up()
{
    Schema::table('users', function (Blueprint $table) {
        $table->boolean('email_permission')->change();
        $table->boolean('sms_permission')->change();
    });
}

/**
 * Reverse the migrations.
 *
 * @return void
 */
public function down()
{
    Schema::table('users', function (Blueprint $table) {
        //
    });
}

but i got the error below

Doctrine\DBAL\Driver\PDOException::("SQLSTATE[42804]: Datatype mismatch: 7 ERROR:  column 
"email_permission" cannot be cast automatically to type boolean
HINT:  You might need to specify "USING email_permission::boolean".")

this is original migration:

   public function up()
{
    Schema::table('users', function (Blueprint $table) {
        $table->string('email_permission')->nullable()->default('0');
        $table->string('sms_permission')->nullable()->default('0');
    });
}

/**
 * Reverse the migrations.
 *
 * @return void
 */
public function down()
{
    Schema::table('users', function (Blueprint $table) {
        $table->dropColumn('email_permission');
        $table->dropColumn('sms_permission');
    });
}

how can i change this field type from integer to boolean ?

Is the DB type postgresql? Does this help? stackoverflow.com/questions/41149554/… — mighty_dev
– mighty_dev, Commented Apr 4, 2021 at 8:21

Afshn · Accepted Answer · 2021-04-04 08:27:43Z

0

i using this way and it work perfectly

 public function up()
{
    Schema::table('users', function (Blueprint $table) {
        DB::statement("ALTER TABLE users 
          ALTER COLUMN email_permission DROP DEFAULT,
          ALTER COLUMN email_permission TYPE BOOLEAN USING email_permission::BOOLEAN,
          ALTER COLUMN email_permission SET DEFAULT FALSE;");
    });
}

answered Apr 4, 2021 at 8:27

Afshn

3231 gold badge5 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

How to convert string to boolean in laravel migration?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related