Andreas Volz wrote:
What is if the cell format is
Number or BLOB? Does sqlite convert it always to char?
Yes, the callback interface is a throwback to a time when all sqlite
data was stored as strings. This interface only supports strings, so all
fields are converted to strings to send to the callback routine.
And how do I find out the cell type?
You can't with the callback interface.
You should really look into using the prepare/step/finalize interface
along with the column_* access functions. They allow much better control
of what you get (and avoid the overhead of unnecessary format
conversions), and allow you to determine the actual stored data types.
For a good example of the new interface you can look at the source for
sqlite3_exec(). It is implemented using the new interface functions. It
prepares your query, runs the prepared query, collects the column names
and field data for each result row, and then calls the callback function.
HTH
Dennis Cote
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
