SQLite Forum

about "strict" mode
Login
Of course there is a finite list of REAL identifiers. 
Are you implying FLOAT8,FLOAT4,etc?
I thunk there would be SINGLE and DOUBLE, but SQLite defaults all to DOUBLE internally for REAL?

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