SQLite Forum

Bug when converting string to boolean?
This is obviously a semantics or usage argument, so there cannot be any obvious winner.  However, you have overlooked James' point that nullness is orthogonal to type.  We might (even in SQLite) speak of a column's type, where it would be useless and practically meaningless for that to be NULL, but its values in particular rows may be NULL or not, and when not they have a conventional type. It would be more accurate to say that possible nullity is a feature of all types (where not excluded by a column constraint) rather than a type by itself.