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.
>
2012年3月27日星期二
Float data type oddity
标签:
database,
datatypes,
float,
microsoft,
mysql,
oddity,
oracle,
replicating,
replication,
server,
sql,
transactional,
type
订阅:
博文评论 (Atom)
没有评论:
发表评论