I have message rules to move Emails to the proper lists. If you would send this to the list(s), with CC to person I would see it. I get hundreds of Email a day and have to organize them to stay sane.
As it is now, I just see names I don't know and delete. Tom ----- Original Message ----- From: "David Patte" <[EMAIL PROTECTED]> To: "William Martell" <[EMAIL PROTECTED]> Cc: "MySQL Main List" <[EMAIL PROTECTED]>; "win32 MySQL List" <[EMAIL PROTECTED]> Sent: Thursday, September 19, 2002 9:03 AM Subject: Re: Fractions > 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 > > > --------------------------------------------------------------------- > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before > posting. To request this thread, e-mail [EMAIL PROTECTED] > > To unsubscribe, send a message to the address shown in the > List-Unsubscribe header of this message. If you cannot see it, > e-mail [EMAIL PROTECTED] instead. > --------------------------------------------------------------------- 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