What storage requirement has FLOAT(24) ? Doc is ambigous
What memory requirement has FLOAT(24) ?
MySQL Ref.manual says in Chapter 10.2 Numeric Datatypes:
"A precision from 0 to 23 results in a four-byte single-precision FLOAT column. A precision from 24 to 53 results in an eight-byte double-precision DOUBLE column."
--> FLOAT(24) = 8 Bytes
However in Chapter 10.5. Data Type Storage Requirements:
"FLOAT(p) 4 bytes if 0 <= p <= 24, 8 bytes if 25 <= p <= 53"
--> FLOAT(24) = 4 Bytes
Which is one true?
Thanks for replies.
Subject
Written By
Posted
What storage requirement has FLOAT(24) ? Doc is ambigous
February 04, 2010 03:01AM
February 05, 2010 10:54AM
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.