Artifact
4e4d8b7ab5f37f6150757f5a843cc63aec03c623:
Ticket change
[4e4d8b7ab5]
- Ticket
[e06c4caff3] NAN storage problem in columns of type 'double' status still Open with 3 other changes
by
mistachkin
2013-03-22 23:45:07.
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
