Re: [sqlite] Re: sqlite3_get_table and non-strings

2006-09-22 Thread Dennis Cote
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

Re: [sqlite] Re: sqlite3_get_table and non-strings

2006-09-22 Thread Mark Richards
> Do you expect sqlite3_get_table to look at char*** pointer and somehow > guess that it's a structure, and figure out types of individual > fields? How would you go about implementing something like that? Ha! Good question. I suppose this has already been broached when the design of

[sqlite] Re: sqlite3_get_table and non-strings

2006-09-22 Thread Igor Tandetnik
Mark Richards <[EMAIL PROTECTED]> wrote: Although it does not appear to be mentioned in the documentation, is it correct to assume that sqlite3_get_table can only handle string datatypes? It can read any data type from the database, but it converts everything to strings before returning to