"Derek Developer" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > In SQLite a NUL is nothing. Inserting a NUL into a column defined as > Integer for example creates a zero length entry not an Integer of > value zero. > > How do traditional databases with static typing deal with this?
The same way. Every column can store a special NULL value, unless explicitly declared NOT NULL. > Do they check the column delaration and convert the NUL to a zero > value upon entry? No. > How does SQLite handle sorting with a column that contains values > (including zero) and NULs? NULL collates before any non-NULL value. > Are the NULs converted to zero for the > purposes of sorting? No. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
