>SQLite tries to store everything on disk as big-endian. That >means it always byte swaps on little-endian machines (basically, >ix86) and omits byte swapping for big-endian machines (which is >to say, everything other than ix86.) The byte swapping happens >for integers *and* floating-point numbers.
When I was doing research [1] a while ago into how little endian architectures store IEEE-754 floating point numbers, I understood that they store them exactly like big endian platforms unlike integer formats. I never found information to suggest they were different though I've never done any experimentation in this area. [1] Both AMD & Intel websites publish (with a little delving) technical documentation on their respective processor architecture. This may give more information on the matter: http://babbage.cs.qc.edu/courses/cs341/IEEE-754.html Regards Nick ******************************************************************** This email and any attachments are confidential to the intended recipient and may also be privileged. If you are not the intended recipient please delete it from your system and notify the sender. You should not copy it or use it for any purpose nor disclose or distribute its contents to any other person. ********************************************************************