System.Data.SQLite
Ticket Change Details
Not logged in
Overview

Artifact ID: 4e4d8b7ab5f37f6150757f5a843cc63aec03c623
Ticket: e06c4caff3c433c80616ae5c6df63fc830825e59
NAN storage problem in columns of type 'double'
User & Date: mistachkin 2013-03-22 23:45:07
Changes

  1. Change icomment to:

    I've added a new connection flag that can help work around the strict type affinity checking normally imposed by System.Data.SQLite.

    The new connection flag is "GetAllAsText" and it will force all column values returned from the SQLiteDataReader.GetValue method to be text, even if their type affinity would suggest otherwise.

    Using this new flag along with the "BindAllAsText" flag, attempting to insert a NaN into the column will actually insert the literal string "NaN" and that string will be returned upon being read via the SQLiteDataReader.GetValue method.

    The check-in is [2cd9814a44]. This feature will appear in the upcoming 1.0.85.0 release.

  2. Change login to "mistachkin"
  3. Change mimetype to "text/x-fossil-plain"