Hi all,
I must be doing something wrong, but it seems to me that case
insensitive like is not working when there are accented letters:


% sqlite3 test.db
SQLite version 3.45.1 2024-01-30 16:01:20
Enter ".help" for usage hints.
sqlite> create table test( i varchar(10), c varchar(10) );
sqlite> insert into test( i, c ) values( 'perciò', 'PERCIÒ' );
sqlite> select * from test where i like '%perciò%';
perciò|PERCIÒ

-- not working
sqlite> select * from test where c like '%perciò%';

sqlite> PRAGMA case_sensitive_like=OFF;
-- not working
sqlite> select * from test where c like '%perciò%';
-- not working
sqlite> select * from test where i like '%PERCIÒ%';
-- working but without accented letters
sqlite> select * from test where i like '%PERC%';
perciò|PERCIÒ


Am I missing somethine here?

Thanks,
Luca