On 16/07/2009 7:24 PM, Uijtdewilligen, Freek wrote:
> INSERT INTO t_rp (x, y, z) > VALUES (1, 1, 0); > it gets stored as (1,1,null). What evidence do you have to support your assertion that it is stored as NULL? As Simon has pointed out, 0 != '0'. If after considering that, you feel you still have a problem, try selecting the offending rows using some criteria that are NOT dependant on column z e.g. select rowid, z, quoted(z), typeof(z) from t_rp where row is offending; BTW, if your assertion is true, this query should give some output: select rowid, z, quoted(z), typeof(z) from t_rp where z is null; HTH, John _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
