On Feb 9, 2016 3:16 AM, "Clemens Ladisch" <clemens at ladisch.de> wrote: > > all text values are UTF-8 by default? > > Yes. It would be possible to configure databases to store text values > as UTF-16, but nobody does this, and they would be converted > automatically when using sqlite3_column_text().
Certainly one might change the type to UTF-16 if one is on a platform that uses that type. Windows, Java, others support such strings natively. Just use sqlite3_column_text16 to avoid UTF-8 conversions. At least, that is how I would expect it to work.
