Laravel (or PHP/MySQL?) cuts float numbers after decimal point

Question

Maybe this is a more general MySQL or PHP question deriving from my lack of knowledge in those fields, but...

So I have an app on Laravel 5.4, Database is MySQL 5.7.17

I have a column in talbe, created via migration:

$table->float('operator_price', 9, 2)->nullable()->change();

(this, according to Laravel docs, should mean that column has type 'FLOAT' with 9 total digits and 2 after decimal point)

When user enters 1000.25 in the form field and saves - it's saved as '1000.25',

But if user enters 10000.25 - it's saved as '10000.2'.

So it cuts the last digit if the number is over 9999.

What may be the reason and how can I fix it?

Thank you.

UPDATE: I've done SHOW COLUMNS FROM tours;

and it shows that column 'operator_price' has type 'float':

What about validation before store? ['amount' => 'max:9999'] — Levente Otta
– Levente Otta, Commented Jan 30, 2018 at 7:55
Have you made sure your migration was successful and the field is actually of type float(8,2)? — user8034901
– user8034901, Commented Jan 30, 2018 at 8:00

The Alpha · Accepted Answer · 2021-01-20 17:59:49Z

17

Actually float/double is not as precise as decimal. For monetary data, the decimal type is recommended, so you should probably use:

$table->decimal('operator_price', 10, 2); // instead of float

Read this for some detailed information and float manual from MySql.

edited Jan 20, 2021 at 17:59

answered Jan 30, 2018 at 8:18

The Alpha

147k30 gold badges294 silver badges313 bronze badges

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

3 Comments

Eric Postpischil Over a year ago

Precision is not the issue, and it is not correct to say that double is not as precise as decimal(10, 2). Double has a precision of one part in 4503599627370496 or better, but decimal(10, 2) is at best one part in 10000000000. The issue is that decimal is commensurate with the values used to store and represent currency. But it should be kept in mind that decimal fails in the same way double does when doing any calculations other than addition, subtraction, or multiplication by integers. E.g., calculating the unit price of something sold three for a dollar cannot be done in decimal.

Ganesh Ghalame Over a year ago

You forgot to mention the column name it should be like $table->decimal('operator_price', 10, 2)

The Alpha Over a year ago

Thanks, @GaneshGhalame, I've fixed it.

aliawadh980 · Accepted Answer · 2019-06-10 15:30:03Z

0

As per Laravel Migration documentation:

$table->float('amount', 8, 2);

FLOAT equivalent column with a precision (total digits) and scale (decimal digits).

answered Jun 10, 2019 at 15:30

aliawadh980

4686 silver badges5 bronze badges

Collectives™ on Stack Overflow

Laravel (or PHP/MySQL?) cuts float numbers after decimal point

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related