mysql: field type of double without scientific notation

I have a Mysql-table with a field of type double. when i retrieve very small numbers from this table I get them allways in a scientific notation: i.e. 8.34e-05. what i have to do, that i get the same number in normal notation: 0.834? thank you for any hints in advance! philipp

Re: mysql: field type of double without scientific notation

Roger Baklund: * Philipp Sutter I have a Mysql-table with a field of type double. when i retrieve very small numbers from this table I get them allways in a scientific notation: i.e. 8.34e-05. what i have to do, that i get the same number in normal notation: 0.834? See