SQLite Forum

about "strict" mode
> Of course there is a finite list of REAL identifiers.<br>
Are you implying FLOAT8,FLOAT4,etc?

Those would be among the plethora of type identifiers accepted without STRICT. My point is that proliferating them should be done only for very good cause.

> I thunk there would be SINGLE and DOUBLE, but SQLite defaults all to DOUBLE internally for REAL?

As the doc linked below says, REAL specifies a 64-bit floating point representation (except see "As an internal optimization, small floating point values ..." there.)

> On performance, does SQLite store data internally as both TEXT and REAL for floating data in non strict mode?

No. See <u>[Datatypes in SQLite v3](https://www.sqlite.org/datatype3.html)</u>.