[sqlite] BLOB type not showing in table description after using create table as

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

Re: [sqlite] BLOB type not showing in table description after using create table as

Tiemogo, Idrissa wrote: When I derive a table from another table containing blob type. The describing the new table doesn’t show “blob. 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 *