2012年3月27日星期二

Float data type oddity

I am replicating data by transactional replication, between 2 float data
types, and I am getting different results. '3294676.0' is replicating as
'3294676.0000000005'. Does anyone know why this is? My procs and table
definitions match, and I shouldn't be expecting to see this.
Float is an aproximate data type, so I'm afraid you should not expect
precission (in any means and areas of usage) from it...
Regards,
Kestutis Adomavicius
Consultant
UAB "Baltic Software Solutions"
"captainkt" <nothing@.fake.com> wrote in message
news:ueaBxyy1EHA.3576@.TK2MSFTNGP12.phx.gbl...
> I am replicating data by transactional replication, between 2 float data
> types, and I am getting different results. '3294676.0' is replicating as
> '3294676.0000000005'. Does anyone know why this is? My procs and table
> definitions match, and I shouldn't be expecting to see this.
>

没有评论:

发表评论