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?
Do they check the column delaration and convert the NUL to a zero value upon
entry?
How does SQLite handle sorting with a column that contains values (including
zero) and NULs? Are the NULs converted to zero for the purposes of sorting?
---------------------------------
Never miss a thing. Make Yahoo your homepage.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users