On 11/16/2015 4:20 PM, Simon Slavin 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
Does too. Column affinity is deduced from declared type, following the rules described here: http://www.sqlite.org/datatype3.html#affname > SQLite doesn't even have a varchar type. ... but it has TEXT column affinity, which "varchar" indicates. -- Igor Tandetnik