Replace floats with doubles to increase precision

Description

A float is a single-precision floating point number. The float does not work well when storing large numbers. Here is an example I posted to the samigo mailing list:

> create table floattest (z float);
> insert into floattest VALUES (2075808);
> select * from floattest;

The result: 2075810

Attachments

1

Activity

Show:
Fixed

Details

Priority

Affects versions

Fix versions

Components

Assignee

Reporter

Conversion Script Required

Yes

Created March 9, 2013 at 5:47 PM
Updated March 23, 2022 at 3:02 PM
Resolved March 15, 2013 at 10:04 AM
Loading...