Float.parse of string number result in a another number in the DB

Question

Why when I float.Parse a string "109.7" and insert the result into the DB to a 'float' column I get 109.69999694824219 instead of 109.7?

I am using Microsoft SQL Server 2008 and C#. The string of the number is taken from a Text input field.

see, for example: stackoverflow.com/questions/2100490/…

shelleybutterfly
– shelleybutterfly

2011-08-13 21:03:04 +00:00
Commented Aug 13, 2011 at 21:03 — shelleybutterfly
– shelleybutterfly, Commented Aug 13, 2011 at 21:03

Leslie Hanks · Accepted Answer · 2011-08-13 21:03:23Z

4

floats do not have full precision. You should use decimal.Parse instead.

answered Aug 13, 2011 at 21:03

Leslie Hanks

2,3773 gold badges32 silver badges42 bronze badges

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

4 Comments

Liron Harel Over a year ago

But my DB column is set to float data type. Do I need to change it to decimal instead of float - I mean for the DB column? or like this: float width = (float)decimal.Parse(w)

Leslie Hanks Over a year ago

Well then you will need to round the number when you pull it out of the database or change the type in the database to a decimal.

billinkc Over a year ago

If you need precision, then your column has the wrong data type. ALTER TABLE dbo.MyTable ALTER COLUMN MyColumn decimal(18,2) With a scale and precision that makes sense for your application

Liron Harel Over a year ago

Thanks, I've changed the column to Decimal

Collectives™ on Stack Overflow

Float.parse of string number result in a another number in the DB

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related