Mark Richards wrote:
I suppose this has already been broached when the design of sqlite3_get_table was addressed.
Mark,
Actually this wasn't broached at that time, because when the sqlite_get_table API was designed, sqlite was typeless. All data was stored as strings, so it was natural to return all data as strings. This is why the legacy APIs sqlite_exec and sqlite_get_table only return strings. These APIs were maintained in the new versions for backwards compatibility. Only legacy programs should be using those APIs, so they would be expecting only string data.
New programs that want to store data using other types should use the new sqlite_prepare/sqlite_bind_*/sqlite_step/slite_column_*/sqlite_finalize APIs. It is much easier than trying to undo the string conversions that sqlite does using the old APIs.
HTH Dennis Cote ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
