Igor, On Mon, Nov 16, 2015 at 4:50 PM, Igor Tandetnik <igor at tandetnik.org> wrote: > 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.
Do you have any idea what would be the affinity if I do this: CREATE TABLE test( field1 PRIMARY KEY, field2); for both field1 and field2? Again I would guess TEXT, but this is just my guess... Thank you. > -- > Igor Tandetnik > > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
