|
|
|
|
Float data not replicated exactly
Why are float values not replicated exactly? For example:
33.333333333333343 -> 33.333333333333336
233.33333333333331 -> 233.33333333333334
I saw a previous post about this, but I'm not satisfied with the answer
"float is an imprecise data type". Note that I don't have this problem with
DTS, let alone backup/restore. And it isn't meerly an issue of display
precision: SQL treats these as different values in <> conditions and the
values return different checksums (which is the real problem for us).
Fri, 14 Jan 2005 09:05:04 -0800
=?Utf-8?B?U3V6YW5uZUogLSBmb3JtZXJseSBpbiBQU1MtU1FM?=
|
|