Define Money Fomat in Laravel

Question

I am trying to save money format in laravel 5.1.

Here is table price define:

$table->decimal(price,6,2);

For instance ; when 1.000,50 Turkish Liras saving to MySQL this format 1.00

How can solve this issue?

Answer 1

You can try defining your price like this

$table->decimal('price',9,3);

Where,

9 is the precision, ie 1234567.89 has a precision of 9

3 is the number of decimal places, ie 123456.789 has a scale of 3

In other words, if we use less decimal-places than 3, we can use remaining for real-number places.

You can refer to this link for about precision and scale of database How do I interpret precision and scale of a number in a database?