artemp/trac2github — Issue #744: Use sqlite_master for SQLite bind()
Author: artemp
Created: 2011-10-09 20:49:14+00:00
State: open
Labels: SQLite_Input_Driver

I recently ran into the issue noted in the code about introspecting SQLite datasources - not only is there a problem in which not having any rows will cause the deciphering of columns to fail, there's also a problem in which columns without NOT NULL declared will also come out as null.

Could we use sqlite_master to be able to decipher type affinity without relying on actual data?

Tagging as Documentation because there isn't an SQLite category for Component.