You can see that e.g. with a select statement: create table test ( Name TEXT, Age Int); INSERT INTO Test VALUES ('Klaus', 22); INSERT INTO Test VALUES ('Meier', '022'); SELECT * FROM Test WHERE Age=22;
In this case, the comparison is made on integers, '022' converted to integer with be equal to 22: Klaus|22 Meier|22 If you use a blob for the age, create table testb ( Name TEXT, Age BLOB); INSERT INTO TestB VALUES ('Klaus', 22); INSERT INTO TestB VALUES ('Meier', '022'); SELECT * FROM TestB WHERE Age=22; you get a binary comparison, returning only Klaus|22 -- View this message in context: http://sqlite.1065341.n5.nabble.com/BLOB-Other-Data-Type-tp70605p70681.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