On Wed, 18 Sep 2002, William Martell wrote: > 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???
Did you consider storing a fraction using 2 integers? That's the way we did it many years ago in Forth. Thomas Spahni -- sql, query --------------------------------------------------------------------- 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
