[FAQ000090]The values registered in the table are different when checked in the table management screen

Q

I registered a value of "0.1" in the "Number (with decimal point)" column of the table,

but when I check it in the Table Management screen, it changes to "0.10000000000000001".

A

The value of "Number (with decimal point)" in the "Table management" screen looks different because of

the difference in display format, but the registered value itself does not change.

Columns that specify "Number (with decimal point)" as the data type will be internally recorded as floating point numbers,

but since floating point numbers handled by computers cannot represent values exactly " 0.1",

the values will contain errors as displayed.

When displaying this floating point number, it is usually displayed as " 0.1" because it is rounded to the nearest significant digit,

but in the "Data" display of the table management screen, it is displayed to a significant number of digits after the decimal point,

so it looks different from the registered value, but as a floating point number, it is the same value. However, as floating point numbers, they are the same.

Related keywords

Format settings, Database, DB