0 Replies Latest reply: May 29, 2002 8:56 AM by 807581 RSS

    I have a database with number values that use a comma as decimal separator. Fort� recognizes these values with DecimalData type and returns a point as decimal separator and no decimal digits.

    807581
      Hello,

      I have a database with number values. Some of these values have decimal digits and use a comma as decimal separator. I connect to a database through Fort� and try to get these values with a SELECT statement. Fort� recognizes these values with DecimalData type and returns a point as decimal separator and no decimal digits. Why does it happen?

      If I try to obtain one of these values with

      SELECT (VALUE_NAME + 0) AS VALUE_NAME

      Fort� recognizes the value with Float type and returns the correct value. What is happening? Can anyone help me ? It would be very appreciated.

      Enrique Arroba