Store NaN Values in SQLite Database

Question

Store NaN Values in SQLite Database

I would like to insert NaN values into a SQLite database.

I have an Ent table with Id, StringColumn and DoubleColumn (cannot be nullable), and I'm trying to use the following SQL statement:

INSERT INTO Ent (Id, StringColumn, DoubleColumn) VALUES (1, 'NaN test', ????)

I do not know what to put in place of '????' for storing NaN.

I access the database using System.Data.SQLite - perhaps this also matters?

+5

sqlite sqlite3 system.data.sqlite

Dariusz wasacz Mar 22 '13 at 11:57

source share

4 answers

SQLite ... lax... . "NaN" , "". "". "", . SQLite .

+4

Dave Sherohman 27 . '13 22:37

SQLite does not have a textual representation of NaN values.

In SQL, special NULLbehaves similarly in calculations and can serve the same purpose.

+1

CL. Mar 22 '13 at 12:45

source share

The trick I'm currently using is to store -Infinity on Real columns when null is not sufficient or invalid (since you have "not null" in that column).

+1

Barton Mar 27 '13 at 21:24

source share

Dariusz wasacz · Accepted Answer · 2013-06-20T11:31:03+0000

I asked the guys from SQLite how to deal with the problem: http://system.data.sqlite.org/index.html/tktview/e06c4caff3c433c80616ae5c6df63fc830825e59 . They added a new connection flag: "GetAllAsText", and now you can store NaN along with the rest (Infinity, -Infinity).

Store NaN Values ​​in SQLite Database

More articles:

Store NaN Values in SQLite Database