SQLite converts strings to dates

How can I stop SQLite converting strings to dates?
The field is varChar but when I add a record containing numbers and decimals eg. MEM5.15C it is stored in the database as 2015-12-05

Are you sure it is not something in you code for the INSERT that is doing it…
Sqlite really doesn’t have strict datatypes (ie. There is no real DATE type)… in reality there are only 5 true “datastores”

  • NULL
  • REAL
  • TEXT
  • Blob

anything you might “specify” is mapped to one of those…with most ending up in TEXT (such as Varchar)

Sorry, I think I found it. I was converting cells with local date format into SQL format before adding.
Unfortunately some strings like the example were recognized as potential dates by parsedate function.