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

Reply via email to