Mario,

m> I am struggling with the strange Interbase behaviour of storing simple
m> float values.

what you are observing is standard floating point behaviour. I suggest
you have a look here:

http://www.math.grin.edu/~stone/courses/fundamentals/IEEE-reals.html

to get the details before half of the list subscribers start flooding
the list with them. :-)

m> If this was the case, then for me it would be the most compelling
m> reason to migrate my databases from Interbase to Firebird !

If you need exact-scale arithmetic you will be glad to know that you
can have that by abandoning FLOAT and DOUBLE and switching to
NUMERIC(x, y), upto 18 significant digits. You can do that in
InterBase as well, but of course there are other reasons why you
should switch to Firebird anyway. :-)

Ciao
--
Nando Dessena
http://www.flamerobin.org
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================