Re: [sqlite] Storage class and Affinity for BOOL/BOOLEAN, NUMBER, FLOAT, DOUBLE ?

RohitPatel <[EMAIL PROTECTED]> wrote: > > I need to know (in SQLite 3.3.4), what will be the internal storage class > and Column Affinity for columns defined in a table with BOOL/BOOLEAN, > NUMBER, FLOAT and DOUBLE ? > > e.g. > CREATE TABLE t1 > ( > bActive BOOL, > bVisible

[sqlite] Storage class and Affinity for BOOL/BOOLEAN, NUMBER, FLOAT, DOUBLE ?

Hi SQLite Gurus, I have gone through online documentation of SQLite3 data types. I need to know (in SQLite 3.3.4), what will be the internal storage class and Column Affinity for columns defined in a table with BOOL/BOOLEAN, NUMBER, FLOAT and DOUBLE ? e.g. CREATE TABLE t1 ( bActive