you could store them as 3 integers. The integral part, the numerator of the fraction and the denominator of the fraction - then interpret them at the client side.
William Martell wrote: > sql,query,database,odbc > > > Hello All, > > Can anyone tell me whether I can represent fractions in MySQL 4. I have > data representing different lengths of objects measured in inches. Can I > load this data as is into a field in MySQL and still retain the same value > or do I have to convert it first to a float or decimal value?? > > What type of data type will the field be bigint, int, decimal??? The > measurements are small, for example 2 1/2 inches, 3 1/8 inches. > > Thanks in advance -- David Patte Relative Data, Inc. ---------------------- MyStars! 2.7 "Shareware for Stargazers" Website #1: http://www.relativedata.com/ Website #2: http://www.mystarslive.com/ 24 Hr Bus. Phone/Fax: 1 (613) 728-4240 --------------------------------------------------------------------- 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