Hello all,

I inherited an SQL table which uses a floating point value as the
ID, and i converted this table into a Firebird Table, maintaining
the floating point type for the ID, however I have noticed the
floating point values are not the same when i view these values, for
example -

SQL Float ID = 110479018921127.0
FDB Float ID = 110479015936000.0

Via ISQL when i perform the - Select * from TABLE WHERE ID =
######################## - both numbers return the exact same
record as indicated by a date/time field

Are there issues with Floats in Firebird { using version 1.5.2 as an
Embedded Server in this instance, but also a Classic Server }

Any help or understanding would be appreciated.

thanks
craig