Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 database underflow error

Author  Topic 

fogofogo
Starting Member

11 Posts

Posted - 2008-10-10 : 11:00:34
Hello all!

Is there anyway of avoiding an underflow error when converting from double to decimal?

I'm using Google Maps which returns gives me coordinates in doubles and I'm storing them in a SQL server database. Some of the coordinates are set to zero, I'm assuming this is because of an underflow error. I store the coordinates as decimals.

Thank you!

hanbingl
Aged Yak Warrior

652 Posts

Posted - 2008-10-13 : 14:08:41
maybe you should use FLOAT datatype instead of cecimal??
Go to Top of Page
   

- Advertisement -