Hi, On Sun, Oct 13, 2019 at 4:12 PM Shawn Wagner <shawnw.mob...@gmail.com> wrote: > > The documentation for a column with NUMERIC affinity says > > > When text data is inserted into a NUMERIC column, the storage class of > the text is converted to INTEGER or REAL (in order of preference) if such > conversion is lossless and reversible. > > But consider: > > sqlite> create table foo(bar numeric); > sqlite> insert into foo values ('0012'); > sqlite> select bar, typeof(bar) from foo;bar typeof(bar) > ---------- -----------12 integer > > > 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?
What version of SQLite do you use? Thank you. > _______________________________________________ > 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