开发者

SQL Server data modification while importing

开发者 https://www.devze.com 2023-01-13 09:36 出处:网络
In mySql, I have a Float field equals to 4.85 When importing into SQL Server 2008 in a开发者_StackOverflow Float field i get, 4,84999990463257

In mySql, I have a Float field equals to 4.85

When importing into SQL Server 2008 in a开发者_StackOverflow Float field i get, 4,84999990463257

Someone has an idea why ?

Thanks Jon


Float values are approximations that are accurate to some number of decimal points. Use decimal data type if you want more specific precision.

http://dev.mysql.com/doc/refman/5.0/en/precision-math-decimal-changes.html

0

精彩评论

暂无评论...
验证码 换一张
取 消