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