mitsuhiko/flask — pull request #655 by oliversong (2012-12-26 05:10:19+00:00)
Title: SQLite doesn't recognize data type "string"

If you submit a field with an integer and commit to DB as a string, SQLite will cast it to an integer, which can cause problems.

I was making something based on the Flask tutorial and I couldn't figure out why my data was coming back as type "int" when I had inserted to the DB as "string".

The field needs to be something that has text-affinity in SQLite, so I changed it to type "text".

Hope this helps?