From: "Tito Ciuro" <[EMAIL PROTECTED]> > Now that 2.8.13 is out, is 'PRAGMA show_datatypes = ON' by default? I > wonder because I'm still not getting the data types in the result set. > > I posted a message yesterday and after upgrading to 2.8.13 I'm still > getting the same results. Can someone *please* give me some pointers?
How are you interfacing to SQLite? Are you using the C API directly? If so, are you using sqlite_exec() with a callback function (the callback API), or are you using the sqlite_compile(), sqlite_step(), and sqlite_finalize() (the newer non-callback API)? These APIs are described here: http://www.hwaci.com/sw/sqlite/c_interface.html Generally speaking, the datatype information follows the column name information in one array, and the column data is returned in a seperate array. For a typical result that returns 3 columns you get something like this: ColumnNames[] [0] -> column 1 name [1] -> column 2 name [2] -> column 3 name [3] -> column 1 type [4] -> column 2 type [5] -> column 3 type Data[] [0] -> column 1 data [2] -> column 2 data [3] -> column 3 data --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
