Conversion between SQL Real and .NET double

Question

I have a column in a T-SQL database that consists of real values, but when I convert it to double I get something different than what was stored.

For example, I pick one row which has 1.15 stored. When I convert it with:

Convert.ToDouble(reader["VAT"]);

I get:

1,14999997615814

Why? And how do I convert a real to double and recieve the same value?

stackoverflow.com/questions/618535/…

gsharp
– gsharp

2014-07-17 09:10:52 +00:00
Commented Jul 17, 2014 at 9:10 — gsharp
– gsharp, Commented Jul 17, 2014 at 9:10
What's the type of your column?

Christos
– Christos

2014-07-17 09:11:09 +00:00
Commented Jul 17, 2014 at 9:11 — Christos
– Christos, Commented Jul 17, 2014 at 9:11

Christos · Accepted Answer · 2014-07-17 10:08:48Z

2

Try to change the data type of your column from real to float. If you visit this link, you will notice that float SQL Server data type maps to Double, Nullable<Double> CLR types. On the other hand, real SQL Server data type maps to Single, Nullable<Single> CLR types. I suspect that's your problem.

answered Jul 17, 2014 at 10:08

Christos

54.1k9 gold badges82 silver badges114 bronze badges

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

Collectives™ on Stack Overflow

Conversion between SQL Real and .NET double

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related