I have already tried DECIMAL type but I cannot get what I want.
Maybe the simple way to get data out of MySQL and data inside MySQL the
same, is to reproduce what MySQL does by default on my data out of MySQL.
> Check out the DECIMAL type.
> / Carsten
> Sebastien MORETTI skrev:
>> I have a row which is defined as double unsigned (MySQL 5.0.26-Max,
>> 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.