In the database, I have a field that is a float that is up to 8 characters long. My question is if I type in 35.20349 how come in the database, it shows up like this 35.203490000000002. <BR>
So your number is as close as it gets.<BR><BR>No matter... when you display it to the somebody, you just format the number into something more readable.
Ok, now I see. Thanks
multiply the value with 100000 and store it as int or bigint
Cause you know managment doesn't like their money being shaved off with those fractions of pennies (seen SupermanIII and Office Space?)<BR><BR>We store all our money as integers...
this is for the latitude and longitude of a place, and it needs to be accurate because on the website, it gives the distance of the place in miles of how far you are from the zip code you enter in.
Cause not many people will notice the difference between 3 miles and 3.1384344 miles.
On the website, it will say that the facility is 3.2 miles from that zip code