>As long as you use _value_bytes after _text you're fine... so if any >conversion did take place the value will be right of the last returned >string type.
JD, Could you explain that to me? I’m not sure why any conversion takes place and, on reading the text below, I would’ve thought it would be better to call sqlite3_value_bytes first (if it’s called “subsequently” the pointer returned by sqlite3_value_text “can be invalidated”). Please pay particular attention to the fact that the pointer returned from sqlite3_value_blob()<https://sqlite.org/c3ref/value_blob.html>, sqlite3_value_text()<https://sqlite.org/c3ref/value_blob.html>, or sqlite3_value_text16()<https://sqlite.org/c3ref/value_blob.html> can be invalidated by a subsequent call to sqlite3_value_bytes()<https://sqlite.org/c3ref/value_blob.html>, sqlite3_value_bytes16()<https://sqlite.org/c3ref/value_blob.html>, sqlite3_value_text()<https://sqlite.org/c3ref/value_blob.html>, or sqlite3_value_text16()<https://sqlite.org/c3ref/value_blob.html>.” _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users