This is also where I seem to be having issues - between the OSX shell and sqlite CLI. Using the Hex codes on <a href="https://utf8-chartable.de/unicode-utf8-table.pl?number=512&utf8=string-literal">this page</a> I can enter properly rendered characters in my bash shell, but not in the sqlite shell. But piping a command to sqlite from the shell works! DUH? I currently run High Sierra 10.13.6 on my main machine and have found using Perl to enter any hex codes to work well. Most of the work I do is in a web environment anyway and Perl is back-end choice, so that works fine. But I have another newer box running Big Sur 11.2.1 running zsh as the default shell. I will get sqlite running on it and see what transpires.