db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Thornton <mthorn...@optrak.co.uk>
Subject float precision
Date Wed, 15 Aug 2007 14:42:36 GMT
Derby rejects a data type of "FLOAT(53)" despite the 
documentation including:

"The default precision for FLOAT is 53 and is equivalent to DOUBLE 

The error given is
java.sql.SQLSyntaxErrorException: Value '53' is not a valid precision 

Although an 8 byte IEEE floating point value has 52 explicit mantissa 
bits, there is also an implicit 1 bit, so 53 is the correct precision 
(at least that is my understanding) for normal values.

suggests that someone thinks 52 is right answer.

Mark Thornton

View raw message