SQLite Forum

about "strict" mode
Login
I prefer this strict mode but chose poorly for my REAL name :(
I use "DOUBLE" instead of REAL. Is there any chance this will be accepted?
...Old notes to self...
SQLite has 5 fundamental datatypes:
SQLITE3
SQLITE_INTEGER     = 1     ; 64-bit signed integer, INTEGER, SMALLINT, etc
SQLITE_FLOAT       = 2     ; 64-bit IEEE floating point number, DECIMAL(10,5), DATETIME, DATE, BOOLEAN, etc
SQLITE_TEXT        = 3     ; String, CHAR, VARCHAR(20), etc
SQLITE_BLOB        = 4
SQLITE_NULL        = 5
STRING CONSTANTS For DDL Statements:
SQLITE_INTEGER     = "INTEGER" ; 64-bit signed integer, INTEGER, SMALLINT, etc
SQLITE_FLOAT       = "DOUBLE"  ; 64-bit IEEE floating point number, DECIMAL(10,5), DATETIME, DATE, BOOLEAN, etc
SQLITE_TEXT        = "TEXT"    ; String, CHAR, VARCHAR(20), etc
SQLITE_BLOB        = "BLOB"
SQLITE_NULL        = "NULL"
...
Will there be a performance advantage using PRAGMA strict=ON;?