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.

>database,sql,query,table just to post :)
>Before posting, please check:
>   (the manual)
>           (the list archive)
>To request this thread, e-mail <mysql-thread98071@stripped>
>To unsubscribe, e-mail <>
>Trouble unsubscribing? Try:

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