Michael Kaufmann wrote: >>> It seems that BLOBs are converted from UTF-8 to UTF-16 when >>> sqlite3_column_text16() is called. > > The sequence of calls is: > > 1. sqlite3_step() > 2. sqlite3_column_text16()
<http://www.sqlite.org/lang_expr.html#castexpr> says: > To cast a BLOB value to TEXT, the sequence of bytes that make up the > BLOB is interpreted as text encoded using the database encoding. (The database encoding must be set when the DB file is created.) Regards, Clemens