> 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>.