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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
