D 2013-03-22T23:45:07.608 J icomment I've\sadded\sa\snew\sconnection\sflag\sthat\scan\shelp\swork\saround\sthe\sstrict\stype\r\naffinity\schecking\snormally\simposed\sby\sSystem.Data.SQLite.\r\n\r\nThe\snew\sconnection\sflag\sis\s"GetAllAsText"\sand\sit\swill\sforce\sall\scolumn\svalues\r\nreturned\sfrom\sthe\sSQLiteDataReader.GetValue\smethod\sto\sbe\stext,\seven\sif\stheir\r\ntype\saffinity\swould\ssuggest\sotherwise.\r\n\r\nUsing\sthis\snew\sflag\salong\swith\sthe\s"BindAllAsText"\sflag,\sattempting\sto\sinsert\r\na\sNaN\sinto\sthe\scolumn\swill\sactually\sinsert\sthe\sliteral\sstring\s"NaN"\sand\sthat\r\nstring\swill\sbe\sreturned\supon\sbeing\sread\svia\sthe\sSQLiteDataReader.GetValue\smethod.\r\n\r\nThe\scheck-in\sis\s[2cd9814a44].\s\sThis\sfeature\swill\sappear\sin\sthe\supcoming\s1.0.85.0\r\nrelease. J login mistachkin J mimetype text/x-fossil-plain K e06c4caff3c433c80616ae5c6df63fc830825e59 U mistachkin Z f73674ac1ec130fbb0b986f1b0b957a7