float column -- Ivan ?

[Ruslan Zasukhin]

On 4/19/12 8:52 PM, "George Parkinson" <george at microtherapy.ca> wrote:

Hi George,

> hello all,
> i have a float column (f) in table t.
> some values do not read back as inserted.
> 
> for example:
> INSERT INTO t (f) values (341.1) -->>  reads back as 341.10001
> INSERT INTO t (f) values (341.2) -->> reads back as 341.20001
> INSERT INTO t (f) values (341.3) -->> reads back as 341.29999
> INSERT INTO t (f) values (341.4) -->> reads back as 341.39999
> INSERT INTO t (f) values (341.5) -->> reads back as 341.50000
> INSERT INTO t (f) values (341.6) -->> reads back as 341.60001
> INSERT INTO t (f) values (341.7) -->> reads back as 341.70001
> INSERT INTO t (f) values (341.8) -->> reads back as 341.79999
> INSERT INTO t (f) values (341.9) -->> reads back as 341.89999
> INSERT INTO t (f) values (341.10) -->> reads back as 341.10001
> 
> the question is: is this normal?

FLOAT/DOUBLE columns have additional parameter decision/scale

Check it ...easiest way using Valentina Studio and your db.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]