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

From Giannis Vrentzos
Subject case insensitive search with greek characters
Date
Msg-id 1092296626.181734@athnrd02
Whole thread Raw
Responses Re: case insensitive search with greek characters  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: case insensitive search with greek characters  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Hi all,

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 α .
I 'm using ENCODING = 'ISO_8859_7'. I also tried with unicode but no luck.

An suggestions?

Thanks,
Gvre

pgsql-general by date:

Previous
From: max jacob
Date:
Subject: Re: table functions as fields in a select
Next
From: François Gendron
Date:
Subject: Virtual Private Database Functionality