Yes, I know. (This all comes from someone on stack overflow who used "string" as a column type and thus ran into this issue because that of course results in numeric affinity)
On Sun, Oct 13, 2019, 4:27 PM Simon Slavin <slav...@bigfraud.org> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users