Ah... that is what I missed. Thanks! On the other hand, why doesn't sqlite give me an error or warning when I used "string", if it has no meaning?
Igor Tandetnik wrote: > > peter360 wrote: >> I see this in sqlite >> >> sqlite> create table t1(c1 string); > > You want t1(c1 text). "string" has no special meaning to SQLite, while > "text" does. > > Igor Tandetnik > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://old.nabble.com/prevent-sqlite-from-interpreting-string-as-numbers--tp28565639p28587341.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users