Subject | Re: [firebird-support] SP float results rounded strangely (dbExpress) |
---|---|
Author | Lester Caine |
Post date | 2005-09-06T09:21:45Z |
Martijn Tonies wrote:
simply not storable in the underlying data field. It WOULD be nice if
one could limit the client to just show the 'accuracy' that is possible
and at least warn where something is not possible - so it is a client
issue.
The isql answer is limited to the available accuracy, but the data
supplied can simply not be handled and was simply trimmed even before
the result was generated?
Personally I avoid FLOAT simply because of the rounding problems ;)
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services
>>isql givesWhat is 'wrong' is that the client is displaying information that is
>>0.66666669
>>
>>so it seems to be client issue. How big is float in Firebird?
>
> A client issue? Howso? "isq" returns an answer just as wrong as
> Delphi.
simply not storable in the underlying data field. It WOULD be nice if
one could limit the client to just show the 'accuracy' that is possible
and at least warn where something is not possible - so it is a client
issue.
The isql answer is limited to the available accuracy, but the data
supplied can simply not be handled and was simply trimmed even before
the result was generated?
Personally I avoid FLOAT simply because of the rounding problems ;)
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services