The missing space is a copy paste error. And the table IS getting created. Only the insertion fails. sqlite return code is 19 (/* Abort due to constraint violation */).
> SQLite has no such type I see nothing in Qt code that converts BOOLEAN in NUMERIC or anything else. The statement is passed as is to sqlite. On previously created sqlite files, when i open then in sqlite manager addon of Firefox, the field is still displayed as BOOLEAN