List:General Discussion« Previous MessageNext Message »
From:Sebastien MORETTI Date:April 14 2010 3:20pm
Subject:numeric types
View as plain text  
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