SQLite stores float values to integer

Question

SQLite stores float values to integer

I am using System.Data.SQLite to save data to a database. The table has 2 columns defined as float. However, when I save data to DB, it only saves the whole part.

12.2345 => 12 11.5324 => 11 (I don't know exactly how it rounds, it just rounds)

Yes, I'm pretty sure I'm using floats in my application, and I'm pretty sure the CommandText contains floating point numbers NOT integers.

+2

c # sql sqlite system.data.sqlite

mnn 25 oct. '09 at 8:18

source to share

2 answers

There is no support for float as a built-in type. Use TEXT instead.

0

Fus 25 oct. '09 at 9:19

source to share

Paul Hsieh · Accepted Answer · 2009-10-25T11:31:40+0000

You need to use floats in your application, but you also need to make sure that the entry in the SQLite database table is explicitly declared as REAL.

SQLite stores float values ​​to integer

More articles:

SQLite stores float values to integer