Laravel Eloquent float value stored in database returned additional numbers

Question

This is my migrations

$table->float('odd', 10, 0)->nullable();

I save odd value in db as 4.45 but it returned as 4.45000000000000017763568394002504646778106689453125
I look this post Laravel Eloquent double value stored in database returned rounded

but that is not solve my problem. Also problems only occur in server
How can solve it?

Can you show how you're retrieving the value from the database? — Rwd
– Rwd, Commented May 26, 2019 at 12:45

Mirko Manojlovic · Accepted Answer · 2020-10-18 13:07:18Z

1

I know I am a little late, but maybe this can help someone.

PHP7.1 json_encode() Float Issue

TLDR

The problem is in serialize_precision in php.ini https://www.php.net/manual/en/ini.core.php

Mine was set to 100 and it caused me the same problems. Setting to -1 resolved it.

answered Oct 18, 2020 at 13:07

Mirko Manojlovic

731 gold badge2 silver badges9 bronze badges

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

2 Comments

Dharman Over a year ago

Did you know that if a question can be answered by another answer on Stack Overflow we do not usually add a new answer? I know you don't have enough reputation to comment, but we post the link in a comment and close the question as a duplicate.

Martin Braun Over a year ago

Another reason to hate PHP. I rounded my floats using the round function, yet json_encode will mess them up.

Collectives™ on Stack Overflow

Laravel Eloquent float value stored in database returned additional numbers

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related