Thunderstone Support Forums

I'm trying to insert a NULL value into a column that is
expecting an integer, i've tried

INSERT INTO mytable (intvalue) VALUES (NULL)
as well as
INSERT INTO mytable (intvalue) VALUES ('NULL')

both of which resulted in a 0 being inserted.

with other DMBS's I've used this is ok..

-- Jeff

Texis does not currently support NULL values, and so you will get a 0 instead.