List:General Discussion« Previous MessageNext Message »
From:MySQL Date:September 20 2002 9:54pm
Subject:Re: Fractions
View as plain text  
   From: "Madscientist" <madscientist@stripped>
   Cc: <win32@stripped>
   Date: Fri, 20 Sep 2002 08:26:21 -0400
   X-Priority: 3 (Normal)
   X-MSMail-Priority: Normal
   Importance: Normal
   X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
   X-Declude-Spoolname: D13f214a.SMD
   News-Group: list.mysql
   Reply-To: <mysql@stripped>

   You might also consider using two integer type fields - one for the
   numerator and another for the denominator. This way storage and recovery are
   easy and the mathematics are wide open.
   _M

I suspect that a float add is faster than 3 integer multiplies and
sum.


   ]-----Original Message-----
   ]From: MySQL [mailto:mysql@stripped]
   ]Sent: Thursday, September 19, 2002 7:51 PM
   ]To: mysql@stripped
   ]Cc: wmartell@stripped; win32@stripped
   ]Subject: Re: Fractions
   ]
   ]
   ]   Mailing-List: contact mysql-help@stripped; run by ezmlm
   ](http://www.ezmlm.org)
   ]   X-Sender: paul@stripped@teton.kitebird.com
   ]   Date: Thu, 19 Sep 2002 08:54:55 -0500
   ]   From: Paul DuBois <paul@stripped>
   ]   News-Group: list.mysql
   ]   Reply-To: <mysql@stripped>
   ]
   ]   At 20:47 -0500 9/18/02, William Martell wrote:
   ]   >Hello.
   ]   >
   ]   >Can anyone tell me whether we can represent fractions in MySQL
   ]4.0.  I have
   ]   >data representing different lengths of objects measured in
   ]inches.  Can I
   ]   >load this data as is into a field in MySQL or do I have to
   ]convert it first
   ]   >into an floating point interger or decimal value???
   ]
   ]   You could store them as strings, but you'd have to interpret them on
   ]   the client side, most likely.
   ]
   ]In which case you might as well store them as reals, with char
   ]substitution (interpret).  As reals, later when the inevitable desire
   ]occurs to add different lengths, it will be simple.
Thread
FractionsWilliam Martell19 Sep
  • Re: FractionsPaul DuBois19 Sep
    • Re: FractionsMySQL20 Sep
      • RE: FractionsMadscientist20 Sep
        • Re: FractionsMySQL21 Sep
        • Re: FractionsMichael T. Babcock23 Sep
  • Re: FractionsThomas Spahni19 Sep
Re: FractionsMichael T. Babcock19 Sep
Re: FractionsJan Steinman22 Sep