SQLite Forum

Unicode and CLI for Mac
As mentioned in the Topic header I'm on a Mac running High Sierra. 
Perl: This is perl 5, version 18, subversion 2 (v5.18.2)

My scripts now have the following added:
use 5.012; # https://perldoc.perl.org/perluniintro
use Encode qw(encode decode);
binmode(STDOUT, "encoding(UTF-8)");
use open ":std", ":encoding(UTF-8)";
When doing a select:
$sth=$dbh->prepare(qq{select name,title,genre,cds.artistid,cdid from cds join artists on artists.artistid=cds.artistid order by cds.id desc limit 5;});
     while (@records=$sth->fetchrow_array()) {

And when adding or updating:
$text=encode('UTF-8',("Ali Farka Touré & Toumani Diabaté"));
$sth=$dbh->do(qq{update artists set name=("$text") where artistid=1373}); 

I believe you are right in thinking I don't need ICU. But in response to another reply, it doesn't seem my console is UTF-8 compatible.

"What is the output of SELECT x'c3a1', hex('á'); " came back empty.
And a select with CLI:
sqlite> select name from artists where artistid in(1373,1786,1558,1653,1771);
Ali Farka Touré & Toumani Diabaté
Café del Mar

I do have the DB updated but had to do it all via Perl.