At 20:32 +0200 1/24/03, Octavian Rasnita wrote:
>Is it the same in all database servers?
It's in the nature of digital devices to represent continuous values
inaccurately.
>
>Teddy,
>Teddy's Center: http://teddy.fcc.ro/
>Email: orasnita@stripped
>
>----- Original Message -----
>From: "gerald_clark" <gerald_clark@stripped>
>To: "Octavian Rasnita" <orasnita@stripped>
>Cc: "Stefan Hinz, iConnect (Berlin)" <list_hinz@stripped>; "MySQL"
><mysql@stripped>
>Sent: Friday, January 24, 2003 4:12 PM
>Subject: Re: Is it normal?
>
>
>Any calculation involving a floating point number will be imprecise.
>It does not mater what column types are involved.
>
>Octavian Rasnita wrote:
>
>>And does anyone know what column type I should use if I want a precise
>>calculation?
>>I've even tried with text and blob, but they are not working either.
> >Only the int type is precise?