From: "Madscientist" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> 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: <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]] ]Sent: Thursday, September 19, 2002 7:51 PM ]To: [EMAIL PROTECTED] ]Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] ]Subject: Re: Fractions ] ] ] Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm ](http://www.ezmlm.org) ] X-Sender: [EMAIL PROTECTED]@teton.kitebird.com ] Date: Thu, 19 Sep 2002 08:54:55 -0500 ] From: Paul DuBois <[EMAIL PROTECTED]> ] News-Group: list.mysql ] Reply-To: <[EMAIL PROTECTED]> ] ] 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. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php