14 Replies Latest reply: Apr 25, 2014 12:21 AM by jagan mohan rao appala RSS

    Integer field after extraction from MySQL DB shows E+ exponential value, HOW-to fix?

    Ram Asokan

      Hi folks,

       

      Please have a look at the image below:

       

      NumFieldIssue.jpg

      After trying to to extract a table from MySQL db, one of the data fields got corrupted. Its an ID field, tried several methods to fix it but failed to solve the issue --> Num(), floor(), int() functions where used. Please advise. Thanks in advance.

       

      Best Regards,

      R