Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-37233

Replace floats with doubles to increase precision

    XMLWordPrintable

    Details

    • 10 status:
      Resolved
    • Conversion Script Required:
      Yes
    • Previous Issue Keys:
      SAM-2087

      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

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  Assignee:
                  samigoteam SAMIGO TEAM (Inactive)
                  Reporter:
                  ottenhoff Sam Ottenhoff
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration