Problem with very small decimals
Posted on 2009-06-29
I am just a novice mysql user so hopefully you will be able to help me.
I am storing some very small numbers in a field of type double. Some of the numbers are being stored as values like this: 8.72852595488195e-005. This is no good to me because some of the 3rd party vb.net components that I work with cannot handle the data in this form (ie. e-005).
Can i prevent the database from storing the values with this notation? Perhaps I need to use a different data type?