On 6 May 2013, at 2:10pm, Simon Slavin <slav...@bigfraud.org> wrote:
> You can format them after retrieving them from the database, or you can > format them before retrieving them from the database before putting them in > the database, in which case you should consider that you're storing strings, > not numbers. Apologies. That should have read You can format them after retrieving them from the database, or you can format them before putting them in the database, in which case you should consider that you're storing strings, not numbers, and be cautious about using them for calculations, even summing a column. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users