On 15 Feb 2017, at 12:22am, Cecil Westerhof <cldwester...@gmail.com> wrote:

> Is there a way to store an INTEGER in a TEXT field?

No.  But you can do it the other way around.  You can store text in an INTEGER 
field.  Just bind it using sqlite3_bind_textnn() or pass a value delimited by 
single quotes.  You’ll find that SQLite is happy to store and retrieve it.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to