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
