Although Tcl does not know NULL at all, sqlite does. From my current unterstanding there are five different fundamental internal datatypes. One of them is SQLITE_NULL. But SQLITE_NULL is not used at all while iterating over the results of
dbcmd eval "SELECT ..."
From my current unterstanding the result of the query is still a C array during this iteration within DbObjCmd and than gets converted to Tcl objects. So it should be simple to extend to use SQLITE_NULL and return a predefined value e.g. if a special PRAGMA is set. In the moment i am to tired to figure out of whether there is an already usable relation to combine it with the sqlite shells .nullvalue command.
It's the first time i've looked in the sqlite code base. Maybe i am wrong.
Is there any experience?
TIA
