>>> From: D Burgess <mailto:dburges...@gmail.com>
>>> You can just store [large integers as] binary blobs and interpret then in >>> the client, no? Or do >>> you need to do arithmetic on them? BLOBs are useful for storage of binary info (e.g., a file), but they are not human readable and require complex conversion when inserting and extracting info from the DB. AFAIK you can't search or index on them. They're a poor substitute for an INTEGER. (FWIW I ended up using a TEXT representation of a large integer, with a custom adapter to convert things back and forth. This can at least be read by a person when looking at data dumps and so on. I considered this the least bad of several bad alternatives! Obviously a native long integer type with normal arithmetic support is the proper solution.) Randall. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
