Michael Penkov wrote: > Hello, > > I'm attempting to use sqlite3 (version 3.5.6, cross-compiled using gcc > 2.95.3) on a Sharp Zaurus CL-3200. Kernel is Linux 2.4.20, armv5tel, > using NetWinder Floating Point Emulator V0.95. > > Overall, it works well, but I am encountering strange problems with > reading and writing floating point values. > > Here is a file to reproduce the problem: > http://repose.ath.cx/tracker/anki/file99/sqlite.tar.gz > > sqlite.tar.gz contains the databases created on a PC and a Zaurus. There is > only one table (float_test) with a single column (float) with a single row > (contains value 1.1). Data type for float is numeric(10,2). Run > test.sh to see how > differently 1.1 is represented between the two platforms. > > Could someone explain why this is so, and suggest what could be done > to solve the problem? Ideally, I would like the database to be > transferable between different platforms. > > A colleague using a Zaurus (albeit a different O/S) has also > reproduced the issue. His specs were: > > Linux kurobox 2.6.20 #1 PREEMPT Thu Aug 30 15:58:28 UTC 2007 armv5tel > GNU/Linux > NetWinder Floating Point Emulator V0.97 (double precision) > debian libsqlite3-0 3.4.2-2 > > A small discussion we've been having about the issue is located here: > http://repose.ath.cx/tracker/anki/issue436, in case I've missed > anything in this initial post. > > Looking forward to your replies. >
Michael, There have been various discussions of ARM floating point data in SQLite. You might find something useful in the archives. A search for ARM floating point int htis list at gmane returns lots of hits. http://search.gmane.org/?query=ARM+floating+point&group=gmane.comp.db.sqlite.general It seems ARM has some unusual handling of endianness that may be causing your problems. HTH Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
