4 Replies Latest reply: Aug 9, 2013 5:55 AM by Michael Vassallo RSS

    strange data misinterpretation

    Michael Vassallo

      Hi,

       

      I have the following scenario:

       

      I am reading codes from the database, where each code consists of numbers and letters. However there are some codes where the letter 'E' is being converted to the letter 'D'. Example:

       

      Temp:

      LOAD * INLINE

      [

      CUSTOMERID, CUSTOMERSTATUS, ADDRESS,                     CODE,

      4879,                    Active,                    0030545578D3,                    84,

      552829,                    Active,                    0030545578E3,                    35,

      ];

       

      If you see the data in a table, you will find that both codes are interpreted to '0030545578D3'.

       

      Do you know why this is happening?

       

      Thanks in advance!