I can not get work ilike, ~*, ~~* with not ascii chars, but upper,lower, order by - work good.db encoding is UNICODE. test=> SELECT 'Тест' ~~* 'тест'; ?column? ---------- f test=> SELECT 'Тест'' ~* 'тест'; ?column? ---------- f test=> SELECT 'Тест'' ILIKE 'тест'; ?column? ---------- f test=> SELECT upper('Тест'') ~~ upper('тест'); ?column? ---------- t tesscom=> SELECT upper('Тест'') ~ upper('тест'); ?column? ---------- t ---------------------------(end of broadcast)---------------------------TIP 4: Don't 'kill -9' the postmaster