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

[RohitPatel9999]

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       BOOL,
  bVisible      BOOLEAN,
  number1       NUMBER,
  number2       FLOAT,
  number2       DOUBLE
);

Thanks for any help or clarification.

Rohit
-- 
View this message in context: 
http://www.nabble.com/Storage-class-and-Affinity-for-BOOL-BOOLEAN%2C-NUMBER%2C-FLOAT%2C-DOUBLE---tf1922928.html#a5265049
Sent from the SQLite forum at Nabble.com.