Store NaN values in SQLite database

sqlite system.data.sqlite
Dariusz Wasacz picture Dariusz Wasacz · Mar 22, 2013 · Viewed 8.8k times · Source

I'd like to insert NaN values into SQLite database.

I have Ent table with Id, StringColumn and DoubleColumn (not nullable) and I try use the following SQL statement:

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

I don't know what to put in place of '????' to have NaN stored.

I'm accessing the database using System.Data.SQLite - maybe this also matters?

Answer

Dariusz Wasacz picture Dariusz Wasacz · Jun 20, 2013

I've asked guys of SQLite how to deal with the problem: http://system.data.sqlite.org/index.html/tktview/e06c4caff3c433c80616ae5c6df63fc830825e59. They've added a new connection flag: "GetAllAsText" and now it is possible to store NaN, along with the others (Infinity, -Infinity).

Related questions

Create SQLite Database and table

Within C# application code, I would like to create and then interact with one or more SQLite databases. How do I initialize a new SQLite database file and open it for reading and writing? Following the database's creation, how do …

Read More
What 'additional configuration' is necessary to reference a .NET 2.0 mixed mode assembly in a .NET 4.0 project?

I have a project in which I'd like to use some of the .NET 4.0 features but a core requirement is that I can use the System.Data.SQLite framework which is compiled against 2.X. I see mention of this being …

Read More
Adding parameters in SQLite with C#

Im just learning SQLite and I can't get my parameters to compile into the command properly. When I execute the following code: this.command.CommandText = "INSERT INTO [StringData] VALUE (?,?)"; this.data = new SQLiteParameter(); this.byteIndex = new SQLiteParameter(); this.command.Parameters.…

Read More