OK, that is very helpful. I must have misunderstood the documentation about this:
The sqlite3_column_type() routine returns the datatype code for the initial data type of the result column. etc> I will just check my application code and there must be something wrong there then. I am sure my UDF is OK. RBS On Wed, Aug 30, 2017 at 12:27 PM, Richard Hipp <[email protected]> wrote: > On 8/30/17, Bart Smissaert <[email protected]> wrote: > > Say I have a query like this: > > > > Select tbl, BlobAsText(sample) from sqlite_stat4 > > Where BlobAsText is a UDF that takes a blob and converts it to a string. > > Now I need to know that the second column of the output needs to be dealt > > with as text. > > Is there any SQLite API that can help me with this? > > > > sqlite3_column_type and sqlite3_column_decltype can't tell me this > > information. > > sqlite3_column_type() should be returning SQLITE_TEXT, unless there is > something wrong with your UDF. > > -- > D. Richard Hipp > [email protected] > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
