http://www.sqlite.org/datatype3.html
F. On Sat, Apr 16, 2011 at 7:40 PM, Tobias Vesterlund <tobias.vesterl...@ericsson.com> wrote: > Hi, > > I ran into something I don't understand, maybe someone here can shed some > light on it for me. > > I have a table named Tg which is created (with tcl) by: > > CREATE TABLE Tg (TgConfigId INTEGER PRIMARY KEY AUTOINCREMENT, > OtherColumn INTEGER); > > If I do: > INSERT INTO Tg (TgConfigId) VALUES (1); > > The following select works: > SELECT * FROM Tg WHERE TgConfigId = 1; > > But if I insert '1' instead I have to select on '1', 1 no longer works. That > makes some sense, but not entirely, as what I inserted isn't an integer any > longer but a string. Why would I be allowed to insert values with '' in a > column that is specified to be an integer? > > Regards, > Tobias > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
