Re: case insensitive search with greek characters - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: case insensitive search with greek characters
Date
Msg-id 200408152142.01788.peter_e@gmx.net
Whole thread Raw
In response to case insensitive search with greek characters  (Giannis Vrentzos <gvre@NOSPAM.gvre.gr>)
List pgsql-general
Giannis Vrentzos wrote:
> I 'm testing postgres 8.0 beta 1 an i have the following problem. I
> have a field with value Γιάννης. If i execute the following query it
> does not returns any rows.
>
> select * from test where descr ilike '%γιαννης%'
>
> if i change the query to
>
> select * from test where descr ilike '%γιάννης%'
>
> everything is fine. As you can see the problem is at char α .

As far as I can see, this is correct, because the pattern in the second
query indeed does match you value whereas the first doesn't.  Did you
expect ilike to be accent-insensitive?  It is not.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/


pgsql-general by date:

Previous
From: Frank van Vugt
Date:
Subject: Re: (libpq) listen/notify messages are converted to lowercase and/or are case insensitive
Next
From: Bruce Momjian
Date:
Subject: Re: pgcrypto/encrypt insertion failes due to \\ (2 slah being