Re: [Firebird-docs] Scale of number and precision on floating data types

2016-08-11 Thread Paul Vinkenoog
Hi all, >> Floating point data types are stored in an IEEE 754 binary format that >> comprises sign, exponent and mantissa. Precision is dynamic, >> corresponding to the physical storage format of the value, which may >> be up to 4 bytes for the FLOAT type and up to 8 bytes for DOUBLE >> PRECISIO

Re: [Firebird-docs] Scale of number and precision on floating data types

2016-08-11 Thread Köditz , Martin
Hi Helen, yes i did. Martin -Ursprüngliche Nachricht- Von: Helen Borrie [mailto:hele...@iinet.net.au] Gesendet: Donnerstag, 11. August 2016 09:26 An: Chatter regarding Firebird documentation Betreff: Re: [Firebird-docs] Scale of number and precision on floating data types Hello

Re: [Firebird-docs] Scale of number and precision on floating data types

2016-08-11 Thread Helen Borrie
n: Chatter regarding Firebird documentation > Betreff: Re: [Firebird-docs] Scale of number and precision on floating data > types > 11.08.2016 06:38, Helen Borrie wrote: >> >> Floating point data types are stored in an IEEE 754 binary format that >> comprises sig

Re: [Firebird-docs] Scale of number and precision on floating data types

2016-08-10 Thread Köditz , Martin
The wording is OK. I will use it. Martin -Ursprüngliche Nachricht- Von: Dmitry Yemanov [mailto:firebi...@yandex.ru] Gesendet: Donnerstag, 11. August 2016 07:19 An: Chatter regarding Firebird documentation Betreff: Re: [Firebird-docs] Scale of number and precision on floating data types

Re: [Firebird-docs] Scale of number and precision on floating data types

2016-08-10 Thread Dmitry Yemanov
11.08.2016 06:38, Helen Borrie wrote: > > Floating point data types are stored in an IEEE 754 binary format that > comprises sign, exponent and mantissa. Precision is dynamic, > corresponding to the physical storage format of the value, which may > be up to 4 bytes for the FLOAT type and up to 8 b

Re: [Firebird-docs] Scale of number and precision on floating data types

2016-08-10 Thread Helen Borrie
Hello Dmitry, Thursday, August 11, 2016, 9:42:48 AM, you wrote: > Nope, floating point numbers are stored completely different to the > fixed point numbers. FLOAT is single-precision format which occupies 4 > bytes. DOUBLE is double-precision format which occupies 8 bytes. But > they have no re

Re: [Firebird-docs] Scale of number and precision on floating data types

2016-08-10 Thread Dmitry Yemanov
10.08.2016 23:35, Helen Borrie wrote: > >> I hang on a text part in fblangref25-datatypes.xml -> >> fblangref25-datatypes-floattypes: >> Floating-point data types are examples of data stored in the DBMS with the >> precision matching the scale of the number. > >> What is the scale of number? Plea

Re: [Firebird-docs] Scale of number and precision on floating data types

2016-08-10 Thread Mark Rotteveel
No, that is not how floating point works. The storage is different from integers or bigint, as it is, the text makes no sense at all. Mark - Bericht beantwoorden - Van: "Helen Borrie" Aan: "Chatter regarding Firebird documentation" Onderwerp: [Firebird-docs]

Re: [Firebird-docs] Scale of number and precision on floating data types

2016-08-10 Thread Helen Borrie
Hello , Wednesday, August 10, 2016, 9:20:50 PM, Martin Koeditz wrote: > I hang on a text part in fblangref25-datatypes.xml -> > fblangref25-datatypes-floattypes: > Floating-point data types are examples of data stored in the DBMS with the > precision matching the scale of the number. > What i

[Firebird-docs] Scale of number and precision on floating data types

2016-08-10 Thread Köditz , Martin
Hi all, I hang on a text part in fblangref25-datatypes.xml -> fblangref25-datatypes-floattypes: Floating-point data types are examples of data stored in the DBMS with the precision matching the scale of the number. What is the scale of number? Please make this clear. Otherwise I don't get the