After reading quite a bit about 'show_datatypes' I still don't get its workings.
After setting 'PRAGMA show_datatypes = ON;' I go ahead and perform a 'SELECT * FROM address_table LIMIT 1;' The resulting set contains 4 columns, 1 row:
[0] --> ROWID [1] --> First [2] --> Last [3] --> Country [4] --> 1 [5] --> Tito [6] --> Ciuro [7] --> Spain
I would think that 'show_datatypes' would append 4 additional elements:
[8] --> INTEGER PRIMARY KEY [9] --> VARCHAR(255) [10] --> VARCHAR(255) [11] --> VARCHAR(255)
but after the SELECT statement is executed, element #8 is NULL. Why is that? What am I doing wrong?
Thanks,
-- Tito