1

Closed

Decimal values losing precision

description

We are losing precision on decimal numbers,
 
numbers like 4.6587 are becoming 5.0000
 
As a workaround I changed line 108 in SQLServerSyntax.cs:
 
return "CAST(" + ToSql(value) + " AS DECIMAL)";
 
new:
 
return "CAST(" + ToSql(value) + " AS DECIMAL(14,4))";
 
but of course a better solution would be to get the correct precision from the database.
Closed May 20, 2011 at 8:28 PM by General1

comments

wrote May 20, 2011 at 8:28 PM

Resolved with changeset 4819.

wrote Feb 2, 2013 at 2:38 AM

wrote May 14, 2013 at 10:23 PM