SQLite Forum

sqlite3_bind_text16 & weird AI
Login
Hi Richard,

I just came across this thread trying to figure out how to check if a string value is stored in UTF-8 or UTF-16, before accessing it with either sqlite3_column_text or sqlite3_column_text16, in order to avoid any conversions.

From your post I now know that all text in a database is stored in a single encoding. This is very useful information, and it could be documented more clearly, possibly in the pragma encoding section.