> On Sep 23, 2019, at 9:53 AM, Pierre Clouthier
> <pclout...@progenygenealogy.com> wrote:
>
> sqlite3_exec("PRAGMA encoding = \"UTF-8\";")
That isn't necessary. SQLite defaults to UTF-8.
In most cases SQLite doesn't interpret the byte sequences in a string. It just
knows it's using an 8-bit character set and leaves it at that. So if the text
is messed up in the database, it's because it was entered in messed-up form.
(Some components do work with non-ASCII text, like FTS, depending on how you've
built/configured SQLite, and those do interpret UTF-8 sequences.)
—Jens
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
