Doctrine 2 - 2 decimal places on a float?

Question

Annotation:

/**
 * @ORM\Column(type="float", scale="2")
 */
protected $curr_price;

I'm using it with Symfony 2.

And this field becomes a double in MySQL database instead of float with 2 point precision.

What am I doing wrong? I tried deleting the DB, reinserting etc...

Though not related to your question, storing prices as a floating point is (generally) a very bad practice. — Martijn, Sep 07 '14 at 14:25
Please see http://stackoverflow.com/questions/1165761/decimal-vs-double-which-one-should-i-use-and-when. — Martijn, Sep 07 '14 at 14:39

score 35 · Accepted Answer · edited Jan 30 '21 at 12:21

35

Both precision and scale properties work only with the decimal mapping type (link). I suggest you use the decimal type.

As to why it's creating a double field instead of float, I'm not entirely sure. It probably has to do with being compatible with all supported databases. I see no mention of double mapping type so I assume they use the same type for both.

edited Jan 30 '21 at 12:21

Boschman

751
1
10
17

answered Sep 04 '11 at 01:15

kgilden

10,236
3
46
46

score 11 · Answer 2 · edited Dec 02 '15 at 12:00

11

in the *.yml

curr_price:
    type: decimal
    precision: 10
    scale: 2

edited Dec 02 '15 at 12:00

Community

1
1

answered Jan 10 '13 at 18:45

juan

355
4
10

could you decrypt please,if I try set 12345678901.2222, what was set ? – shuba.ivan Mar 27 '20 at 17:05

score 10 · Answer 3 · edited Apr 19 '13 at 17:11

10

/**
 * @ORM\Column(type="float", scale=2)
 */
protected $curr_price;

scale should be an integer, and you are using a string

edited Apr 19 '13 at 17:11

Dan Esparza

27,508
28
100
124

answered Apr 19 '13 at 16:53

Serhii Polishchuk

1,410
16
21

1

According to [docs](http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/reference/basic-mapping.html#property-mapping): *scale: (optional, default 0) The scale for a decimal (exact numeric) column (**applies only for decimal column**), which represents the number of digits to the right of the decimal point and must not be greater than precision.* – Martin Janeček Jun 11 '15 at 08:25

Doctrine 2 - 2 decimal places on a float?

3 Answers3

Linked