Julian Bui <julian...@gmail.com> wrote: > One thing I don't understand is, you wrote: > > sqlite> CREATE TABLE foo (a INTEGER PRIMARY KEY, b NOTABLOB); >> > > I take it that "NOTABLOB" is any data type I want, since "NOTABLOB" > is not a > keyword/datatype. Doesn't that mean I will restrict myself to a > single > datatype?
SQLite will accept pretty much any sequence of words as a column type. It doesn't really mean much to the engine. You could do CREATE TABLE foo (a LOREM IPSUM); and it would work. For more details, see http://sqlite.org/datatype3.html Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
