On 13 Oct 2019, at 10:11pm, Shawn Wagner <shawnw.mob...@gmail.com> wrote:
> As you can see, the leading zeros in the original string are gone and it's > been converted to an integer. This seems to violate the "lossless and > reversible" constraint. Shouldn't it be kept as text? You defined the column as 'numeric'. Had you defined it as 'text' you would get different behaviour. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
