I am using sqlite 3.8.6 on MacOSX Yosemite 10.10.2. When I derive a table from another table containing blob type. The describing the new table doesn’t show “blob". See below:
sqlite> select sqlite_version(); 3.8.6 sqlite> create table t1 (p_id int, geometry blob); sqlite> pragma table_info(t1); 0|p_id|int|0||0 1|geometry|blob|0||0 sqlite> create table t2 as select * from t1; sqlite> pragma table_info(t2); 0|p_id|INT|0||0 1|geometry||0||0 sqlite> Thanks _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users