Simon, On Mon, Nov 16, 2015 at 4:20 PM, Simon Slavin <slavins at bigfraud.org> wrote: > > On 16 Nov 2015, at 9:09pm, Igor Korot <ikorot01 at gmail.com> wrote: > >> 1|name |varchar(100)|0 | |0 > > Note that this does not tell you anything about the affinity of the column, > or the types of the values in it. SQLite doesn't even have a varchar type.
No, it does not. But I would guess it should have a "string" affinity. Is there a command to check on that? > >> "dflt_value" field may or may not have a value. > > > It might be interesting to know what type the value in the above line has. The type or affinity? Thank you. P.S.: I just made that table as compatible with other DBMS. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users