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
]-----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 ] ] --------------------------------------------------------------------- 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
