Laravel Default Value for Decimal Column Type

Question

I'm trying to set a default value for a decimal column. But I still received a "Not null violation error".

What I have tried:

None of what I've tried works. Does anyone know how to fix this?

have you tried default(0.00), pass other non-zero double like 0.12 in order to validate format or disabling SQL strict mode? — moonvader
– moonvader, Commented Nov 2, 2021 at 6:19
the migration is probably working, but you are passing the null value in the query when you insert new records — porloscerros Ψ
– porloscerros Ψ, Commented Nov 2, 2021 at 7:02

jason · Accepted Answer · 2021-11-02 06:23:54Z

0

try this

$table->decimal('exit_fee', 19, 2)->default('00000000000000000.00');

and run migrate will see

answered Nov 2, 2021 at 6:23

jason

1

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

1 Comment

still not null violation

ouflak · Accepted Answer · 2021-11-02 09:26:13Z

0

I saw this in a different question wich kind of resembles your question.

$table->decimal('exit_fee', 19, 2)->default('00000000000000000');

ouflak

2,56310 gold badges46 silver badges53 bronze badges

answered Nov 2, 2021 at 8:00

bgeertsema2000

777 bronze badges