On 23 Sep 2019, at 5:53pm, Pierre Clouthier <pclout...@progenygenealogy.com> wrote:
> Can anyone explain how to write UTF-8 in SQLite on the Mac? > > We use this statement: > > sqlite3_exec("PRAGMA encoding = \"UTF-8\";") This is not a SQLite problem, but a problem with escaping the quotes in language you're using to execute sqlite3 calls. What programming language or script system are you using ? Will it accept any other way to escape the quote marks ? It should be possible to find a line of code which works on all platforms your compiler supports. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users