Wsrtjtyk

Within one of my Symfony applications I encountered a strange behavior of the doctrine ODM. What I'm trying to do is simply saving decimal typed data to our Informix database. Whenever I try to do so everything behind the decimal separator is cropped.

I tried several ways of assigning data such as:

• $position->setFrpProz(1.2345);


• $position->setFrpProz("1.2345");


• $position->setFrpProz("1,2345");

The result in the database is always: 1.0000

This is the yml for the entity:

frpProz:

        type: decimal

        nullable: true

        precision: 10

        scale: 4

        column: frp_proz

Within Informix the database field is also defined as Decimal(10,4).

I already tried the Doctrine EchoSQLLogger with following results (shortend):

"START TRANSACTION"

UPDATE st_frb_mpos SET frp_proz = ?, [...] WHERE [...]

array(15) {

  [0]=>

  string(6) "1.2345"

                          [...]

}

array(15) {

  [0]=>

  string(7) "decimal"

                          [...]

}

"COMMIT"

"okay"

I really don't know how to solve this. I already tried to upgrade my application from symfony 2.8.? to 3.4.15 - no difference in this topic.

Thanks for your help!

you are misunderstanding the meaning of scale.

Taken from the mysql docs.

The precision represents the number of significant digits that are stored for values, and the scale represents the number of digits that can be stored following the decimal point.

Because you have specified 10,4 the database is only storing 4 decimal places to the right of the point.

Precision is the total amount of digits to be stored. So 10,4 would allow you to store values such as 123456.7890

Hense any value you store will be cropped to 4 decimal places.

Although in Informix you defined the receiving column as DECIMAL(10,4), its acting like you defined it as DECIMAL (10,0) and rounding 1.2345 to 1.0000, so maybe Symfony rounded it to 1.0000 before sending it to Informix?.. That's my suspicion of what's happening because its showing the 4 decimal zero's in Informix, which is a valid value for the precision/scale you defined. So I suggest you research your Symfony frp_proz NumberType field options, such as scale and rounding_mode, to see if the number is being transformed in Symfony.

https://symfony.com/doc/current/reference/forms/types/number.html

Have you experimented casting it to CHAR before sending to Informix, or defining the Informix column as a FLOAT datatype to see the result?