> On Sep 23, 2019, at 1:25 PM, Simon Slavin <slav...@bigfraud.org> wrote:
>
>> 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.
>
My guess is that it isn’t a language issues, as it sounds like they are working
on a multi-platform program, but that they are reading in a file that isn’t
UTF-8 and trying to insert it directly (and getting a Unicode coding error
because the data isn’t UTF-8), or the file IS UTF-8 but they don’t think it is
so they run a conversion on it to convert to UTF-8 from some other character
set, and that is throwing an unrecognized character error.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
