> Is there a way to change the NULL representation ... ? No. Tcl has no null value. Usually this is not a problem, but if you really need to distinguish between a missing value and an empty string, you can use default values.
sqlite> create table deftest (k integer primary key, ...> i integer default '?', ...> s char default '??'); sqlite> insert into deftest (i) values (11); sqlite> insert into deftest (i, s) values (22, ''); sqlite> select * from deftest; k i s ---------- ---------- ---------- 1 11 ?? 2 22 Regards
