Re: [sqlite] BLOB & Other Data Type

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

Re: [sqlite] BLOB & Other Data Type

differ (see the referenced page for examples). -Ursprüngliche Nachricht- Von: techi eth [mailto:techi...@gmail.com] Gesendet: Donnerstag, 22. August 2013 06:08 An: General Discussion of SQLite Database Betreff: [sqlite] BLOB & Other Data Type Hi, What is difference by using Colum

[sqlite] BLOB & Other Data Type

Hi, What is difference by using Colum data type as blob or Any other (Text,INT,REAL,NUMERIC) http://www.sqlite.org/datatype3.html According to above link I understand “The value is a blob of data, stored exactly as it was input”.I beleive that it what required. Ex : Please let me know