Money, float values | How many bits?

[Q&A] General
1

Hi there,

  • How are money values stored in Novulo? 128-bit decimals, 64-bit floats (double precision), 32-bit floats?
  • How are floats stored in Novulo? 64 or 32 bits?

Within a data definition, the data type of a field can be float (decimal), but they normally are two separate data types. Does that mean that there are no floats and everything is stored as a 128-bit decimal?

2

This can be determined by the precision. In the updatescripts you’ll notice that default float fields will be stored as DECIMAL(15,2). This is editable in the architect:

Directly under the money setting the arrows will let you set how many decimals are stored. In the field you can then see how many 0’s are visible. In this case you can also see that the highlighted field allows for positive and negative values and that it is a function field.

image
image591×564 26.8 KB

(The same settings for pos/neg and number of decimals can be set for the number type, only the currency is specific to the money type. The database sees no difference)

3

Hi Elena, what does the setting “i” stand for, in the number of decimals?

4

This i, when you go past 0 characters to the -1 position, is only available in functions. It will display what is necessary: so if you do 0.3\*2 it will display 0.6, but of you do 0.3\*1.5 it will display 0.45

I think the i stands for implicit but I’m not sure on that.