Subject | Re: [ib-support] Re: Strange roundings in IB-5.6 |
---|---|
Author | Entrebytes S.L. |
Post date | 2002-04-03T11:41:10Z |
In fact , i have to mantain installations with IB 5.5 , 5.6 ,6.0 , FB 1.0
and in SCO , Linux , Win98 , NT and 2000..... with the same database and
client.... ranging from 2 to 60+ users....
Sometimes i fancy how many time will pass before i go insane..
Javi
EntreBytes S.L.
Ontenient , Spain
ERP Development.
and in SCO , Linux , Win98 , NT and 2000..... with the same database and
client.... ranging from 2 to 60+ users....
Sometimes i fancy how many time will pass before i go insane..
Javi
EntreBytes S.L.
Ontenient , Spain
ERP Development.
----- Original Message -----
From: "Martijn Tonies" <martijn@...>
To: <ib-support@yahoogroups.com>
Sent: Wednesday, April 03, 2002 1:22 PM
Subject: RE: [ib-support] Re: Strange roundings in IB-5.6
> Hi,
>
> Oops - totally true... I usually forget about IB < 6 :)
>
> Martijn Tonies
> InterBase Workbench - the developer tool for InterBase and Firebird
> http://www.interbaseworkbench.com
>
>
> --- 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 -
> if
> > 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.
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>