MySQL & Servoy float vs Decimal

rgansevles:
There was indeed functionality in Servoy 3.5.7 when a number was entered in the length field.
However, the length was not actually used in the code to create the column in the database, when a non-zero length was specified a number(19, 2) column was created, regardless of the length entered.

Hi Rob,

I would have preferred that the code that is used to create column would have taken the length into account, in stead of ignoring it.
Now we get lot of float types in the database, which means possible problems with roundings (3,14 can be 3,14000000001 and when comparing 3,14 with 3,14000000001 these are not equal)
This happens because I noticed also that javascript sometimes uses 3,14000000001 in stead of 3,14; I guess that is because javascript doesn’t have any types for variables.

And so more management to check if developers change the float type into numeric(19,x) (or similar type in other database); otherwise this 3,14000000001 will be put in database also, with all the problems that can give.

rgansevles:
We decided to remove the functionality because it was incomplete and confusing.

I can understand that when functionality is not complete and therefor confusing that it needs to be fixed. But in my opinion the change that was made, was not best one for us developers.

Martin

Hi.
I agree that removing the functionality is not helpful, as it was quite often useful to be able to force back-end to create either a float or a numeric :cry:

Rafi