List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 30 2002 7:39pm
Subject:RE: float/decimal ?
View as plain text  
At 20:10 +0100 1/30/02, Vasoczki Ferenc wrote:
>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 ?

You can't store commas in numeric column types.

>
>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 <mysql-thread98071@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-paul=snake.net@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Thread
RE: float/decimal ?Vasoczki Ferenc30 Jan
  • RE: float/decimal ?Paul DuBois30 Jan
  • RE: float/decimal ?Steve Rapaport30 Jan