Use a 48-to 64 bit int. When you print or calculate, divide by 10^12. It's called fixed-point arithmetic.
-steve P.S. Ignore the funny guy talking about the commas, he's never been outside his country. -----Original Message----- From: Vasoczki Ferenc [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 8:11 PM To: '[EMAIL PROTECTED]' Subject: RE: float/decimal ? I need to store data like 12,213142124 where the decimal places can be 12. What column type should i use ? I tried float(4) but that is use only 2 decimal places, and i also tried decimal(12,12) but that is give me back 9.99999999 for 10,704704 ? vaso database,sql,query,table just to post :) --------------------------------------------------------------------- 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
