Subject RE: [ib-support] Re: Strange roundings in IB-5.6
Author Martijn Tonies

Oops - totally true... I usually forget about IB < 6 :)

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird

--- In ib-support@y..., "Martijn Tonies" <martijn@b...> wrote:
> Hi,
> InterBase isn't lying to you - it's returning FLOATING POINT values.
> Floating point values aren't precise, never, not in any language -
> you want exact numerics, use NUMERIC(15, 2) or so as the datatype.
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Martijn, you forgot to say "and FB/IB6 dialect 3 instead of IB5.6"
:) Since both Numeric and Decimal with precision greater than 9 are
stored as floating point types, real data will be stored accordingly
this underlying types and can cause some headache on usage in
expressions and aggregates gathering.

Best regards, Alexander V.Nevsky.