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?

      Hi folks,


      Please have a look at the image below:



      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,