ilike, ~*, ~~* does not work on 8.0.3 (db encoding - UNICODE)

From: Sergey Levchenko <sector119(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: ilike, ~*, ~~* does not work on 8.0.3 (db encoding - UNICODE)
Date: 2005-06-14 15:44:52
Message-ID: e3ffbf24050614084422f6dfbc@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Danny Gaethofs 2005-06-14 17:52:58 server not starting
Previous Message Vivek Khera 2005-06-14 15:39:46 Re: PostgreSQL Certification