Kbase P81331: Float Data Type in MS SQL Server displays different value than was assigned
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
20/05/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
FACT(s) (Environment):
MS SQL DataServer
SYMPTOM(s):
float Data Type in MS SQL Server with precision of 15
Data Type in Progress Database is decimal with 3 decimals
data not being display properly
data not being assigned the same from progress to SQL server
CAUSE:
In SQL Server Database, float data type is preserved as accurately as the binary numbering system can offer. This is an approximate numeric data type. The value that is retrieved from SQL Server may not be exactly what was stored originally in the column.
FIX:
Create the column in SQL Server as a real number like a Decimal or Numeric data type.