On 13 Jun 2019, at 10:01pm, Donald Shepherd <donald.sheph...@gmail.com> wrote:

> Given there's been numerous comments to the effect that SQLite now supports
> -0.0 storing and retrieval other than printing, I'm curious which version
> this was implemented in as I wouldn't mind removing my custom code when we
> move to a SQLite version with this improvement.

For auditing and probity reasons, I would store the values twice: once in a 
BLOB and another time in a REAL.  When you need to look at the value you can 
choose which one to look at depending on why you're looking at it.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to