Your declarations affect the AFFINITY of the columns (integer, text, integer) vs. (none, none, none). In both cases the actual types are (integer, text, integer) and will be stored exactly thus. The difference can be seen only when the declared type of the column and the actual type of the data 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 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 -------------------------------------------------------------------------- Gunter Hick Software Engineer Scientific Games International GmbH Klitschgasse 2 – 4, A - 1130 Vienna, Austria FN 157284 a, HG Wien Tel: +43 1 80100 0 E-Mail: h...@scigames.at This e-mail is confidential and may well also be legally privileged. If you have received it in error, you are on notice as to its status and accordingly please notify us immediately by reply e-mail and then delete this message from your system. Please do not copy it or use it for any purposes, or disclose its contents to any person as to do so could be a breach of confidence. Thank you for your cooperation. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users