Not that this is a big difference, but I noticed when looking at the code for sqlite3_value_numeric_type() that it checks for numeric types in text values, but not in blobs values, but that sqlite3_value_double(), sqlite3_value_int() and sqlite3_value_int64() appear to look for numeric strings in blob values as well. Which come to think about it, is a bit of an odd thing to do. I'm not particularly worried about being passed numeric strings in blob values, but it does seem that sqlite3_value_numeric_type() and the sqlite3_value_* numeric functions ought to behave the same.
Best regards, Peter _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
