Mailing List Archive


Back to the month index Back to the list index
John Hascall (john@iastate.edu)
Sun, 08 Sep 1996 10:24:43 CDT 

Message-Id: <9609081524.AA02538@pooh.cc.iastate.edu>
Subject: Re: [mSQL] A few miscellaneous questions... 
Date: Sun, 08 Sep 1996 10:24:43 CDT
From: John Hascall <john@iastate.edu>

> > This real number "bug" concerns me. If I insert a 2.5 into the
> > database, sometimes it might print out as 2.50000000001.
>
> This is the way floats work; the base-2 representation can't represent
> base-10 numbers exactly. It has nothing to do with msql. If it
> bothers you, use fixed-point integers.

   True, in general. However, 2.5 is exactly representable,
   so if that prints as 2.50000000001 then something is wrong.
   However, I'd guess it is more likely a flaw in your stdio
   library than in mSQL.

John
--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!