OverflowException reading decimal value from db

Question

I have a sql server column defined decimal(32,15). When I try to read it using SqlDataReader.GetValue(), I find that the maximum db value that can be accommodated is 79,228,162,514,264. A larger value throws an overflowexception. This is surprising, since the .net decimal type is 128 bits and provides 28 to 29 digits of precision. Can someone explain?

mr.Reband · Accepted Answer · 2013-10-07 18:58:19Z

2

Use SqlDataReader.GetSqlDecimal() instead of SqlDataReader.GetValue().

Here is an example of the problem in detail:

http://weblogs.sqlteam.com/mladenp/archive/2010/08/31/when-does-sql-server-decimal-not-convert-to-net-decimal.aspx

answered Oct 7, 2013 at 18:58

mr.Reband

2,4312 gold badges20 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Elroy Flynn Over a year ago

Interesting. Thanks for the link. Looks like a .net defect.

rory.ap · Accepted Answer · 2013-10-07 19:15:21Z

1

This also works: SqlDataReader.GetProviderSpecificValue()

answered Oct 7, 2013 at 19:15

rory.ap

35.7k15 gold badges104 silver badges199 bronze badges

Collectives™ on Stack Overflow

OverflowException reading decimal value from db

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related