Hi, On Mon, Sep 23, 2019 at 11:58 AM 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\";")
You should probably use this inside #ifdef _WINDOWS .... #endif Thank you. > > This works fine on Windows, but on macOS the data is not being stored > correctly. > > The data to be written (passed to SQLite), is formatted in UTF-8. > > For example, 'é' is U+00E9, which in UTF-8 is 0xC3A9. However, in the > macOS version of the database, it is converted to 0xEFBFBD, which is > U+FFFD, which doesn't make sense. > > -- > Progeny Genealogy Inc. 902–681–3102 > Progeny helps you tell the Story of Your Family ™ > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users