RohitPatel9999 <[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 BOOLEAN, > number1 NUMBER, > number2 FLOAT, > number2 DOUBLE > ); >
The internal storage class will depend on what data you store. The affinity will be NUMERIC, NUMERIC, NUMERIC, REAL, REAL, respectively. -- D. Richard Hipp <[EMAIL PROTECTED]>
