IntegerValue when column has not been set

If, in a given SQLite database row in my resultset, a column has no default value in the schema and has had no value previously assigned to it, what value do I get if I try to retrieve the IntegerValue?

myInt = rs.Field("some_integer_column").IntegerValue

Do I get zero into myInt? What about other values I could ask for, such as BooleanValue, StringValue (into the appropriately Dim-ed variables, of course)?

why don’t you try it and see?

All data types have a default value when casted from NULL to this data type.
boolean would give false.

OK thanks. That agrees with observed behaviour.

Try .Value first. If the database field contains NULL it should return Nil in Xojo.