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
