> On the other hand, why doesn't sqlite give me an error or warning when I > used "string", if it has no meaning?
You probably didn't read this http://www.sqlite.org/datatype3.html, did you? Pavel On Mon, May 17, 2010 at 2:59 PM, peter360 <peter...@fastmail.us> wrote: > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
