On Thu, 2005-08-18 at 14:10 -0400, D. Richard Hipp wrote: > On Thu, 2005-08-18 at 09:40 -0700, Robert Simpson wrote: > > http://www.psc.edu/general/software/packages/ieee/ieee.html > > > > The way I interpreted this site, is that the IEEE standard for floating > > point numbers was processor agnostic and the storage of the bits went from > > left to right. > > > > I wrote a test program to print out the byte values for 1.0 and 1 > on both ix86 (Intel, Linux) and powerpc (G5, OS-X). The results: > > ix86: 000000000000f03f 0100000000000000 > powerpc: 3ff0000000000000 0000000000000001 > > This seems to validate the approach taken by SQLite, which is to > byteswap floating point values on ix86 machines. >
As a double-check, I have confirmed that floating-point values written into an SQLite3 database file written on intel/linux are readable on max/os-x and vice versa. -- D. Richard Hipp <[EMAIL PROTECTED]>