Docs for Determination of Column Affinity, says that if SQLite doesn't otherwise recognize the name, the affinity is NUMERIC. NONE doesn't appear to be recognized. If you want TEXT, say TEXT (or some alternate spelling, like CHAR).
Docs for Determination of Column Affinity, says that if SQLite doesn't otherwise recognize the name, the affinity is NUMERIC. NONE doesn't appear to be recognized. If you want TEXT, say TEXT (or some alternate spelling, like CHAR).