I see this in sqlite
sqlite> create table t1(c1 string);
sqlite> insert into t1(c1) values('100.200');
sqlite> select * from t1;
100.2
but I don't want sqlite to treat 100.200 as a number. I want to treat it as
a string (it is the first two octets of an ip address). How do I achieve
that?
--
View this message in context:
http://old.nabble.com/prevent-sqlite-from-interpreting-string-as-numbers--tp28565639p28565639.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
