Subject Re: [firebird-support] Problem when Updating Column With Float DataType
Author Helen Borrie
At 07:43 AM 26/09/2003 +0000, you wrote:
>When I tried to update a column with float datatype, the value that I
>updated is not what I enter earlier.
>for example:
>update table1 set value = 44090914
>where id = 1;
>when I retrieve this record, the value is 44090912. is it hit the
>maximum value of float data type ?

It has exceeded the maximum precision of the float type (7 digits) and even
seven digits is approximate. Use double precision for 6 to approximately
15 digits of precision.

Read up on the precisions of various number types in the IB6 Data
Definition Guide.