typeof(val) returns the data type of a value. The type of typeof itselfs is text. The returned strings are one of integer, real, text, null or blob. create table tq84_typeof (col);
insert into tq84_typeof values ( 1 );
insert into tq84_typeof values ( 1.0 );
insert into tq84_typeof values ('1.0');
insert into tq84_typeof values ( null);
insert into tq84_typeof values ( zeroblob(20));
.mode column
.width 10 30
.nullvalue '<null>'
select col, typeof(col) from tq84_typeof;
--
-- 1 integer
-- 1.0 real
-- 1.0 text
-- <null> null
-- blob
drop table tq84_typeof;