mORMot Open Source

jbroussia

Member

From: France

Registered: 2011-04-09

Posts: 74

Columns defined as float instead of real, does it matter ?

Hi,

So after defining my data classes and having mORMot create the tables for me (SQLite3), I see that columns that should contain floating point values (in my case, properties defined as "double" in Delphi) end up being defined as "FLOAT" in SQLite3. Shouldn't it be "REAL" instead ? It probably doesn't matter but I'm curious about the reason behind.

Thanks.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,661

Website

Re: Columns defined as float instead of real, does it matter ?

It doesn't matter for Sqlite3.
See https://www.sqlite.org/datatype3.html