On 17 Aug 2015 at 16:50, Olivier Barthelemy <barthelemy at geovariances.com> wrote:
>> 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 Of course. But SQLite itself has no BOOLEAN type, that is the point. So if you declare a column as BOOLEAN in CREATE TABLE, that will in fact become a NUMERIC column. And just because the Firefox addon shows it as BOOLEAN, does not make it so. See: <http://www.sqlite.org/datatype3.html> -- Cheers -- Tim