SQLite Forum

Unicode and CLI for Mac
> It seems this thread (as helpful as it has been) is out of scope for this forum so I don't want to take up any more resources here.

Yes, it's getting that way. But the general problem, of transferring coded characters into and out of a SQLite DB, via its CLI or other means, it on-topic and not uncommon.  This thread is useful for solving your problem and showing methods for diagnosing others like it.