unicode - Using UTF8 INSTR in SQLite -

i'm trying use instr function in sqlite returns wrong value if use utf8 character. how can avoid problem?

select instr('akçe', 'a'); --returns 1 (correct) select instr('akçe', 'k'); --returns 2 (correct) select instr('akçe', 'ç'); --returns 0 (wrong) select instr('akçe', 'e'); --returns 3 (wrong) 

works me:

> select instr('akçe', 'ç'); 3 > select instr('akçe', 'e'); 4 

apparently, not using utf-8.

check output of select quote(cast('ç' blob)); x'c3a7'.