Please run this test for me on your RISC OS system: > ~~~~ make sqlite3 dbtotxt rm -f byteorder.db ./sqlite3 byteorder.db 'CREATE TABLE t1 AS SELECT 1579060583422312000000.0 x;' ./dbtotxt byteorder.db ~~~~ Post the output of "dbtotxt" command on this chat thread. I'm expecting to see this output: > ~~~~ | size 8192 pagesize 4096 filename byteorder.db | page 1 offset 0 | 0: 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 SQLite format 3. | 16: 10 00 01 01 00 40 20 20 00 00 00 01 00 00 00 02 .....@ ........ | 32: 00 00 00 00 00 00 00 00 00 00 00 01 00 00 00 04 ................ | 48: 00 00 00 00 00 00 00 00 00 00 00 01 00 00 00 00 ................ | 80: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 01 ................ | 96: 00 2e 57 48 0d 00 00 00 01 0f dc 00 0f dc 00 00 ..WH............ | 4048: 00 00 00 00 00 00 00 00 00 00 00 00 22 01 06 17 ................ | 4064: 11 11 01 31 74 61 62 6c 65 74 31 74 31 02 43 52 ...1tablet1t1.CR | 4080: 45 41 54 45 20 54 41 42 4c 45 20 74 31 28 78 29 EATE TABLE t1(x) | page 2 offset 4096 | 0: 0d 00 00 00 01 0f f4 00 0f f4 00 00 00 00 00 00 ................ | 4080: 00 00 00 00 0a 01 02 07 44 55 66 77 88 99 aa ff ........DUfw.... ~~~~ I'm interested in the last 8 bytes of output, which should be "44 55 66 77 88 99 aa ff". What are those 8 bytes on your RISC OS system?