"Eggert, Henri" <[EMAIL PROTECTED]> wrote: > How does sqlite recognize a boolean value ? > Does sqlite know that bool , Bool , boolean ... are booleans ? >
There is not a separate boolean datatype. SQLite just happens to have a more efficient storage mechanism for integer values 0 and 1. Prior to version 3.3.0, such integers required 2 bytes of space in the database file. Beginning with version 3.3.1, they require just one byte. -- D. Richard Hipp <[EMAIL PROTECTED]>