List:General Discussion« Previous MessageNext Message »
From:Carsten Pedersen Date:April 14 2010 6:24pm
Subject:Re: numeric types
View as plain text  
Check out the DECIMAL type.

/ Carsten

Sebastien MORETTI skrev:
> Hello,
> 
> I have a row which is defined as double unsigned (MySQL 5.0.26-Max, 
> OpenSuse).
> 
> Values in this row can go from a single digit, like 1, to values like 
> 0.0006872207 or 1.2513e-18.
> 
> 
> 
> I want to store exact numbers.
> But I would like also this:
> 1         stored as 1.00000
> 0.098         stored as 0.09800
> 0.00707     stored as 0.00707
> 0.0006872207     stored as 0.0006872207
> 
> How could I get this ?
> MySQL stores at least double(6,5) but increases this automatically if 
> the precision required is longer.
> 
> 
> Thanks
> 
> -- 
> Sébastien Moretti
> 
> 
Thread
numeric typesSebastien MORETTI14 Apr
  • Re: numeric typesCarsten Pedersen14 Apr
    • Re: numeric typesSebastien Moretti16 Apr