> Also note that if you store your numbers as strings, indexes on those > values will order them as strings. In other words, searching and sorting > will work incorrectly.
> It should be possible to get your numbers from a Java numeric variable to > a database numeric value without passing them through a string at any > point. And, of course, back out of the database into a numeric variable. > If your database library does not allow this, you have a serious problem. > > > As a solution purely about SQLite, SQLite has a "black box" type of BLOB. > BLOB is used to store bytes, without putting any interpretation on those > bytes. Although technically you can search and sort BLOBs, it's probably > a sign of faulty thinking. If I was trying to store something in a > database which I didn't want interpreted in any way, I'd use a BLOB. > > Simon. Hello, Since the purpose of the code is to replicate a database SQL query to a memory/file SQLite database then it seems appropriate to maintain the integrity of the fields as closely as possible. I shall look at treating the fields for numbers as a generic numeric variable in Java. The original code derived from obtaining input from a user, so therefore strings, and parsing to check for valid input before storing. PostgreSQL max/min BigInt are fitting in fine as SQLite's Integer. Thank you for comments. danap. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
