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.