FLOAT and scientific notation
Hi, it seems like when large numbers are stored within a FLOAT column that the number gets stored in a scientific notation (e.g. 1245000 becomes 1.245e+06). My column is price/monetary data, so I don't want this type of notation.
How can I disable this so that MySQL doesn't automatically store my numbers in scientific notation?
Thanks for reading. Any help on this is very appreciated.
Edited 1 time(s). Last edit at 05/19/2009 06:51PM by Sam Holmes.
Subject
Written By
Posted
FLOAT and scientific notation
May 19, 2009 06:50PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.