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 difference between below two operration. CREATE TABLE Test ( ID INT PRIMARY KEY NOT NULL, NAME TEXT NOT NULL, AGE INT) INSERT INTO Test (ID,NAME,AGE) VALUES (1, 'Test', 32); Or CREATE TABLE Test ( ID BLOB PRIMARY KEY NOT NULL, NAME BLOB NOT NULL, AGE BLOB) INSERT INTO Test (ID,NAME,AGE) VALUES (1, 'Test', 32); Cheers - Techi _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users